By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
| CLASSSTRUCTUREID | CLASSIFICATIONID | PARENT |
|---|---|---|
| 1001 | FLEET | null |
| 1002 | LIGHTDUTYVEHICLE | 1001 |
| 1004 | MEDIUMDUTYVEHICLE | 1001 |
| 1022 | ACTIVETRANSPORTATION | null |
| 1023 | FACILITYWALKWAY | 1022 |
| 1024 | TRAIL | 1022 |
| 1085 | SIDEWALK | 1022 |
| 1091 | SDWRAMP | 1085 |
| CLASSSTRUCTUREID | CONNECT_BY_ROOT(CLASSIFICATIONID) |
|---|---|
| 1001 | FLEET |
| 1002 | FLEET |
| 1004 | FLEET |
| 1022 | ACTIVETRANSPORTATION |
| 1023 | ACTIVETRANSPORTATION |
| 1024 | ACTIVETRANSPORTATION |
| 1085 | ACTIVETRANSPORTATION |
| 1091 | ACTIVETRANSPORTATION |