M2 - Bases de dades / Continguts UF2: Ampliacio SQL

Consultes Jeràrquiques

https://www.toadworld.com/platforms/oracle/b/weblog/archive/2015/10/19/como-construir-consultas-jer-rquicas

select  concat(lpad(' ', level * 3 - 3), last_name) nombre
from employees
connect by prior employee_id = manager_id
start with manager_id is null;