随机读取表中一条数据

SELECT * FROM (SELECT * FROM up_merchant_info order by dbms_random.value) WHERE rownum =1;

原文地址:https://www.cnblogs.com/bchange/p/9494870.html