1.树
select 2009 + (level - 1) from dual connect by level <= 12
?
2.递归
找小弟
?select? *
from?? t_sys_org?? start?? with??? orgid in (select? orgid from?? t_sys_org?? where?? name ='广州技术开发服务中心')
? connect?? by?? prior?? orgid=orgpid
找大哥
select? *
from?? t_sys_org?? start?? with?? name ='广州技术开发服务中心'
? connect?? by?? prior?? orgpid=orgid? and orgpid = '9999999999999999999'
?
?