Advertisement
Maks140888

Untitled

May 31st, 2022
809
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.12 KB | None | 0 0
  1. select LPAD(' ', 5*level)||name as tree
  2. from objects start  WITH parent_id is null
  3. CONNECT by prior object_id = parent_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement