ORACLE checks all upper nodes based on root node

1. Basic data

SELECT * from Table_muen T

ID CODE NAME Parentcode

0 first-sbzhyw Social Security integrated ROOT
1 Second-sbzhyw-zzyw self-service first-sbzhyw
2 Third-sbzhyw-ywcxydy business Query and print Second-sbzhyw-zzyw
3 Four-sbzhyw-grcbzmdy Personal Insurance Certificate Printing Third-sbzhyw-ywcxydy

2.SQL

SELECT connect_by_root(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 checks all upper nodes based on root node