SELECT LEVEL, SUB, SUPER
FROM   PARTS
CONNECT WITH PRIOR SUPER = SUB

##</code><code>##

SELECT, LEVEL, LPAD('   ', LEVEL, SUB), SUPER;