随机排序函数
dbms_random.value()
用法:select * from tablename order by dbms_random.value()
行数字段
rownum
用法:select * from tablename where rownum<=10
随机排序函数
dbms_random.value()
用法:select * from tablename order by dbms_random.value()
行数字段
rownum
用法:select * from tablename where rownum<=10