Oracle Output tree structure

Oracle Output tree structure

tree structure, root 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

Tree structure, Primary subdirectory 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 utility function Use case list

Oracle Output tree structure