select null,null --补几个空行
from dual connect by rownum<=5
--找树型
select * from gx_bdjbxxt
[color=red]connect by prior[/color] t.bdbm=t.sjbdbm
[color=red]start with [/color]t.sjbdbm='1231221'
from dual connect by rownum<=5
--找树型
select * from gx_bdjbxxt
[color=red]connect by prior[/color] t.bdbm=t.sjbdbm
[color=red]start with [/color]t.sjbdbm='1231221'