Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT wbs_id, name, wbs_level, parent_wbs_id, sys_connect_by_path(wbs_id, ' / ') path --sys_connect_by_path(name, ' / ') path
- FROM wbs
- START WITH parent_wbs_id IS NULL
- CONNECT BY prior wbs_id = parent_wbs_id
- ORDER siblings BY parent_wbs_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement