Applying Oracle 10g’s Hierarchical Query options

(Scott Stephens) Oracle 10g adds new pseudo columns to the SQL Hierarchical Queries that use START WITH . . . CONNECT BY . . . clauses. For instance, you could specify a starting condition and continue to child rows using one or more connection conditions. As an example, suppose I have a table that

Read More - Register for Free Membership