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 |