摘要:1、从表中随机取记录select * from (select * from staff order by dbms_random.random)where rownum < 4表示从STAFF表中随机取3条记录2、产生随机数SELECT DBMS_RANDOM.RANDOM FROM DUAL;产...
阅读全文
posted @ 2014-11-13 09:04
posted @ 2014-11-13 09:04