Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select LPAD(' ', 3*level-1)|| name as tree
- from object_types START WITH parent_id is null
- CONNECT BY PRIOR object_type_id = parent_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement