create table test(col1 int,col2 int);
insert into test value(1,null)
...
insert into test value(100,null)update test a set a.col2=MOD(ABS(DBMS_RANDOM.RANDOM),100);
insert into test value(1,null)
...
insert into test value(100,null)update test a set a.col2=MOD(ABS(DBMS_RANDOM.RANDOM),100);
dbms_random.values(m,n)
SQL> select * from zyz2;
ID P1 P2
---------- ---------- ----------
1 211 212
2 12 14
4 241 242
2 145
1 11
3 17 26 rows selected.Elapsed: 00:00:00.50
SQL> select id,p1,p2 from (select zyz2.*,dbms_random.random num from zyz2 order
by num) where rownum<3; ID P1 P2
---------- ---------- ----------
2 12 14
1 211 212Elapsed: 00:00:00.30
SQL> select id,p1,p2 from (select zyz2.*,dbms_random.random num from zyz2 order
by num) where rownum<3; ID P1 P2
---------- ---------- ----------
3 17 2
2 12 14