oracle 查询出一个自增列的表

SELECT ROWNUM AS fnumber FROM dual CONNECT BY ROWNUM <= 100

常用于查询缺失编号

如：获取test_table 中缺失的最小id，无最小id获取最大id+1  (v_max_id为先查出test_table 中的最大id)

SELECT MIN(t.id) INTO v_min_miss FROM

(SELECT ROWNUM AS id FROM dual CONNECT BY ROWNUM <= v_max_id+1) t

LEFT JOIN test_table b ON t.id = b.id

WHERE b.id IS NULL;

转载自 CSDN-专业IT技术社区

原文链接：https://blog.csdn.net/rrrgy236116/article/details/170598055