查找子类
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
分类:
Oracle
本文转自快乐就好博客园博客，原文链接：http://www.cnblogs.com/happyday56/archive/2007/06/25/794613.html，如需转载请自行联系原作者
![【数据库】解决 oracle: SQL 错误 [900] [42000]: ORA-00900: 无效 SQL 语句](https://ucc.alicdn.com/pic/developer-ecology/f790f8e9ea28458da1cf5cbb69a7d12a.jpg?x-oss-process=image/resize,h_160,m_lfit)
