Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Function that Iterates down a structure
"mike" <hillmw_at_charter.net> a écrit dans le message de
news:1110662707.023117.280670_at_l41g2000cwc.googlegroups.com...
| 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
|
"order siblings by" is only available on version 9 and up. What's your version?
Btw, order the siblings by struct_level is meaningless as all siblings have the same level.
Regards
Michel Cadot
Received on Sun Mar 13 2005 - 00:40:18 CST