Advertisement
Maks140888

Untitled

Jun 1st, 2022
1,052
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.38 KB | None | 0 0
  1. create or replace function find_object_level(obj_x VARCHAR2)
  2. RETURN number as lvl_object number;
  3. begin
  4.     SELECT level
  5.     into lvl_object
  6.     from objects
  7.     where name = obj_x
  8.     START WITH  parent_id is null
  9.     CONNECT BY PRIOR object_id = parent_id;
  10.    
  11.     return lvl_object;
  12. end;
  13.  
  14. select find_object_level(name) from objects where name = 'Томас Шелби'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement