Oracle tree SQL query

Select typecode, lpad ('', 4 * level-1) | typename
From ajtype
Start with p_code is null connect by prior typecode = p_code;

Result:

1	+ City appearance and sanitation
15	+ Lighting management
151	+ Installation rejected
15101	+ Refuse to install night scene lighting facilities
152	+ Illegal installation
15201	+ Do not install night scene lighting facilities at specified locations
15202	+ Do not install night scene lighting facilities as required
15203	+ Do not install night scene lighting facilities as required
15204	+ Night scene lighting facilities are not installed in the specified light source color
153	+ Don't light on time

 

 

Select sys_connect_by_path (typename, '>') typename
From ajtype
Start with p_code is null connect by prior typecode = p_code;

1	> City appearance and sanitation
15	> City appearance and sanitation> lighting management
151	> City appearance and sanitation> lighting management> Installation rejected
15101	> City appearance and sanitation> lighting management> Installation rejected> Installation of night scene lighting facilities rejected
152	> City appearance and sanitation> lighting management> illegal installation
15201	> City appearance and sanitation> lighting management> illegal installation> night scene lighting facilities are not installed according to the specified location
15202	> City appearance and sanitation> lighting management> illegal installation> night scene lighting facilities are not installed as required