Connect By Challenge!

From: Amy K. Moore <akm111_at_yahoo.com>
Date: 8 Aug 2001 13:23:59 -0700
Message-ID: <966fcac1.0108081223.39098cc@posting.google.com>

I'd love some help with this.

Let's say I've got a family tree type of database with:

person, parent, older_sibling

as columns, and I want to output this data in a tree structure. By using:

     SELECT person, parent, older_sibling
     FROM table_name
     START WITH parent = 'Eve'
     CONNECT BY parent = PRIOR person

I get a tree structure, but the siblings aren't in any particular order. I've read that Oracle 9 now has an ORDER SIBLINGS BY option, but for now I'm stuck with Oracle 8.

Can anyone steer me in the right direction to get the siblings in order?

Thanks a million,
Amy Received on Wed Aug 08 2001 - 15:23:59 CDT