2012年2月13日 - Why not simply: SELECT level, * FROM accounts START WITH parent_account_id = account_id CONNECT BY PRIOR account_id ...
stackoverflow.com