Detect hierarchy loops with Oracle 10g’s new hierarchy pseudocolumns

(Bob Watkins) In a previous tip, I described how to sort the entries in a hierarchical query. For a hierarchical query to work, however, the data must not loop back upon itself. That is, a parent row may not list itself or one of its child rows as its own parent. If this were the case, Oracle could

Read More - Register for Free Membership