Skip to content Skip to sidebar Skip to footer
Home / Oracle10g / Recursive Query / Sql

Oracle - Recursive Query Using Start With... Connected By...?

Post a Comment
Say i have the following table, using Oracle 10g ARTIFACT_LABEL | DEPENDANT_ON test1 | abc1 test1 | abc2 test1 | abc3 abc3 | xyz

Solution 1:

Since you are starting at the bottom of the tree and working up, change the last part of the query to:

PRIOR DEPENDANT_ON = ARTIFACT_LABEL

Post a Comment for "Oracle - Recursive Query Using Start With... Connected By...?"