Using Where Clause with Hierarchical Queries

Using where clause in hierarchical queries may be confusing. Oracle first evaluates the joins in the query if there are any. Then, next step, selects rows in hierarchical order. Finally, applies remaining where clause conditions.

Read More - Register for Free Membership