Oracle 随机取一行数据?从表中随机取一条数据select * from (select * from tab order by dbms_random.val
Oracle 随机取一行数据
?从表中随机取一条数据
select * from (select * from tab order by dbms_random.value) where rownum=1 ;??出处?http://javas.blog.51cto.com/2153666/457485?
Oracle 随机取一行数据
?从表中随机取一条数据
select * from (select * from tab order by dbms_random.value) where rownum=1 ;??出处?http://javas.blog.51cto.com/2153666/457485?