值区间示例:
select id from (select id from (SELECT rownum id from dual connect by rownum<= rpad(12,7,'9')) where id > rpad(12,7,'0')) a
(select id from (SELECT rownum id from dual connect by rownum<= rpad(12,7,'9')) where id > rpad(12,7,'0')) a
where not exists (select id FROM tab where tab like'12%' and id = a.id)