From: akm111@yahoo.com (Amy K. Moore)
Newsgroups: comp.databases.oracle.misc
Subject: Connect By Challenge!
Date: 8 Aug 2001 13:23:59 -0700
Organization: http://groups.google.com/
Lines: 23
Message-ID: <966fcac1.0108081223.39098cc@posting.google.com>
NNTP-Posting-Host: 162.93.14.73
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 997302239 5555 127.0.0.1 (8 Aug 2001 20:23:59 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2001 20:23:59 GMT


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