select * from categories t CONNECT by PRIOR t.id=t.parent_categories_id start with t.parent_categories_id=0 ORDER SIBLINGS BY t.id
说明:不能有DISTINCT语句出现!
select * from categories t CONNECT by PRIOR t.id=t.parent_categories_id start with t.parent_categories_id=0 ORDER SIBLINGS BY t.id
说明:不能有DISTINCT语句出现!