hi,
I am trying to get me head around the difference between CONNECT BY PRIOR and CONNECT BY LEVEL
I can see how CONNECT BY PRIOR basically defines the parent / child relationship in a hierarchy within a table.
Q1. What does CONNECT BY LEVEL do ? Is if simply for creating a series of integers ?
Q2. LEVEL seems to be Psuedo column and therefore appears to be different from PRIOR ?
Q3. What therefore is PRIOR ? Can it only be used by the CONNECT BY clause ?
any help appreciated
Jim