17,078
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM (SELECT t.*
FROM table_name t
ORDER BY dbms_random.value())
WHERE rownum < n;
希望对你有所帮助SELECT A FROM T
insert into T(A)
SELECT dbms_random.value() FROM DUAL CONNECT BY ROWNUM<=100000