Oracle 輸出樹形結構

標籤：name   子目錄   where   函數   href   url   cat   html   spring   

Oracle 輸出樹形結構

樹形結構，根 select connect_by_root(cat.parentid) root,cat.id,cat.parentid,cat.name,cat.code from V cat start with cat.parentid in (37558) connect by prior cat.id= cat.parentid

樹形結構，一級子目錄 select connect_by_root(cat.id) root,cat.id,cat.parentid,cat.name,cat.code from A cat start with cat.parentid in (select id from bto_c2.category_new where parentid = 37558) connect by prior cat.id= cat.parentid

 

ORACLE 實用函數使用案列

Oracle 輸出樹形結構