dbms_random包可能要另外安装 不知道你的有没有 select dbms_random.value(1,5) from dual;
insert into TABLE_NAME(a,b ) values ( v,ceil(dbms_random.value(0,5)));
SQL> set serveroutput on SQL> declare 2 i integer; 3 begin 4 select dbms_random.value(1,5) into i from dual; 5 dbms_output.put_line('i=' || i || ';'); 6 end; 7 / i=5;PL/SQL procedure successfully completed.SQL> set serveroutput on SQL> declare 2 i integer; 3 begin 4 select dbms_random.value(1,5) into i from dual; 5 dbms_output.put_line('i=' || i || ';'); 6 end; 7 / i=2;PL/SQL procedure successfully completed.要是没装dbms_random包,运行一下$oracle_home\ora81\rdbms\admin\dbmsrand.sql即可
不知道你的有没有
select dbms_random.value(1,5) from dual;
)
values (
v,ceil(dbms_random.value(0,5)));
SQL> declare
2 i integer;
3 begin
4 select dbms_random.value(1,5) into i from dual;
5 dbms_output.put_line('i=' || i || ';');
6 end;
7 /
i=5;PL/SQL procedure successfully completed.SQL> set serveroutput on
SQL> declare
2 i integer;
3 begin
4 select dbms_random.value(1,5) into i from dual;
5 dbms_output.put_line('i=' || i || ';');
6 end;
7 /
i=2;PL/SQL procedure successfully completed.要是没装dbms_random包,运行一下$oracle_home\ora81\rdbms\admin\dbmsrand.sql即可
http://www.itpub.net/showthread.php?s=&threadid=41702
insert into TABLE_NAME(a,b
)
values (
v,abs(mod(dbms_random.random,5))+1);
......
我的8.1.5就没有,运行dbmsrand.sql也不行,编译错误。
好像要执行不止一个文件。