首页 > 代码库 > oracle 树sql

oracle 树sql

1   SELECT t.guid,2             t.name,3             t.price,4             t.parentguid   5      FROM test t6     start with t.parentguid= 48D37AB8-EA5D-4D91-9CAA-A986F35891W47     connect by t.parentguid=prior t.guid8     ORDER SIBLINGS BY T.guid

 

oracle 树sql