Re: Function that Iterates down a structure

Michel,

Cool, my qry:

SELECT struct_id, par_struct_id, chd_struct_id, struct_level FROM struct

   START WITH chd_struct_id='4'
   CONNECT BY PRIOR chd_struct_id=par_struct_id    ORDER SIBLINGS BY struct_level

produced the error "ORA-00924: missing BY keyword"

If I take off the Order by line it works fine, but it is not ordered.

Documentation shows that I can do this successfully.

See anything wrong?

Mike Received on Sat Mar 12 2005 - 15:25:07 CST