Understand Oracle 10g’s new Hierarchical Query options

(Scott Stephens) Oracle 10g adds new pseudo columns to the SQL Hierarchical Queries that use START WITH . . . CONNECT BY . . . clauses. For more than a decade, Oracle SQL has had the ability to cause a query to follow a hierarchical relationship. For instance, you could specify a starting condition

Read More - Register for Free Membership