摘要：
with tab as ( select ‘2001’ d from dual union all select ‘2002’ d from dual union all select ‘2003’ d from dual union all select ‘2006’ d from dual un 阅读全文
摘要：
SELECT * FROM ORGANIZE START WITH PARENT_ID = '1409' CONNECT BY PRIOR PARENT_ID = TID start with 后面，某级以下为ID，某级以上为父ID connect by prior 后面某级以下ID在等号左边，某级 阅读全文