ORACLE 根据根节点查所有上层节点

(ID),
CONNECT_BY_ROOT(T.CODE) CODE,
CONNECT_BY_ROOT(T.NAME) NAME,
CONNECT_BY_ROOT(T.PARENTCODE) PARENTCODE
FROM TABLE_MUEN T
WHERE T.CODE = ‘FOUR-SBZHYW-GRCBZMDY‘
CONNECT BY PRIOR T.CODE = T.PARENTCODE

 

ORACLE 根据根节点查所有上层节点

标签：table   个人   ble   根据   社保   oracle   ora   基本   select