Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select LPAD(' ', 5*level)||objects.name as "exersize3"
- FROM objects JOIN object_types USING (object_type_id)
- where level < (
- select level from objects where name = 'ін-94-1'
- start with parent_id is null CONNECT by prior object_id = parent_id
- ) + 1
- START WITH objects.name = 'ін-94-1'
- CONNECT by prior objects.object_id = objects.parent_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement