Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select LPAD(' ', 5*level)||name as tree
- from objects start WITH parent_id is null
- CONNECT by prior object_id = parent_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement