create or replace procedure p_student_add is begin insert into Student(student_id, first_name, last_name,GPA,dept_name) select ceil(dbms_random.value(1,1000000)), dbms_random.string('w',4), dbms_random.string('x',4), dbms_random.string('x',4), dbms_random.string('i',4) from dual connect by rownum <= 10000;
DBMS_RANDOM.VALUE这东西不行啊
is
begin insert into Student(student_id, first_name, last_name,GPA,dept_name)
select ceil(dbms_random.value(1,1000000)),
dbms_random.string('w',4),
dbms_random.string('x',4),
dbms_random.string('x',4),
dbms_random.string('i',4)
from dual
connect by rownum <= 10000;
commit; end;
随机插入数据
http://blog.csdn.net/wh62592855/archive/2009/12/11/4988781.aspx可以参考一下上面的链接