Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> got it... for anyone who's interested...
>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 CST