create table tmp as
select PackageMath36.AddNumber('B80020',rownum - 1) as hphm from all_tab_columns
where rownum<=PackageMath36.MinusStr('B80099','B80020')select b.hphm1,decode(a.hphm,null,'不存在','存在') from
tmp b,vehicle a where b.hphm1=a.hphm(+) order by hphm1
select PackageMath36.AddNumber('B80020',rownum - 1) as hphm from all_tab_columns
where rownum<=PackageMath36.MinusStr('B80099','B80020')select b.hphm1,decode(a.hphm,null,'不存在','存在') from
tmp b,vehicle a where b.hphm1=a.hphm(+) order by hphm1
select * from (select rownum no,tbname.* from tbname) where no<=XXX;