oracle数据库中随机抽取n条数据
select * from (select * from 表名 order by dbms_random.value) where rownum<n
或
select * from (select * from 表名 order by sys_quid()) where rownum<n
select * from (select * from 表名 order by dbms_random.value) where rownum<n
或
select * from (select * from 表名 order by sys_quid()) where rownum<n