第一种:
select * from (select * from 表名 order by dbms_random.value)where rownum<=2
第二种:
select * from 表名 sample(10) where rownum<=2
第一种:
select * from (select * from 表名 order by dbms_random.value)where rownum<=2
第二种:
select * from 表名 sample(10) where rownum<=2