ORDER SIBLINGS BY

Are there any ways to simulate "Order siblings by" in 8i?

select id,parent,name,level,display_order from catalog start with catalogid = 0
connect by prior catalogid = parent
order siblings by display_order

this would probably work fine in 9i, but I can't use the sibling keyword in 8i :( Can anyone help?

thanks in advance, Received on Mon Aug 19 2002 - 17:22:37 CDT