oracle 主要语句大荟萃

查找子类
select org_id,org_pid,org_name
from organization
start with org_id='Lvxin' connect by prior org_id=org_pid
查找父类
select org_id,org_pid,org_name
from organization
start with org_id='Lvxin' connect by prior org_pid=org_id