Advertisement
gsemmobile

WBS

Jul 7th, 2017
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.24 KB | None | 0 0
  1. SELECT wbs_id, name, wbs_level, parent_wbs_id, sys_connect_by_path(wbs_id, ' / ') path --sys_connect_by_path(name, ' / ') path
  2. FROM wbs
  3. START WITH parent_wbs_id IS NULL
  4. CONNECT BY prior wbs_id = parent_wbs_id
  5. ORDER siblings BY parent_wbs_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement