Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TYPE objects_below IS TABLE OF VARCHAR2(200);
- create or replace function find_objects_below(obj_x VARCHAR2)
- return objects_below as object_name objects_below;
- begin
- select name
- bulk collect into object_name
- FROM objects
- START WITH objects.name = obj_x
- CONNECT by prior object_id = parent_id;
- return object_name;
- end;
- select * from table(find_objects_below('розклад'));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement