got it... here's the answer for anyone interested...
From: Andy Ganse <andy_ganse_at_psmfc.org>
Date: 1998/02/26
Message-ID: <34F5E833.6E23_at_psmfc.org>#1/1
Date: 1998/02/26
Message-ID: <34F5E833.6E23_at_psmfc.org>#1/1
>A guy in another newsgroup said he remembered some kind of Oracle
>extensions to handle tree-structured data in tables, but he didn't
>remember what they were and I can't seem to find anything about it
>in my manuals.And he was right. (I finally found it.) Oracle has a feature called
'hierarchical queries', just for this purpose. They involve some extra
clauses that are added to your SQL statement, including keywords such
as CONNECT BY and START WITH. You can find them in the Oracle SQL
Language Reference Manual...
-Andy
Received on Thu Feb 26 1998 - 00:00:00 CET