oracle 取随机数据

--取随机数据
select dbms_random.value from dual;
select * from temp_tpg_qyxx sample(1); --百分比
原文地址:https://www.cnblogs.com/tianmingt/p/4196045.html