Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: putting a tree structure into a relational model

Re: putting a tree structure into a relational model

From: John Gasch <jgasch_at_erols.com>
Date: Fri, 31 Mar 2000 21:35:56 -0500
Message-ID: <38E5608C.BEA2D005@erols.com>


If you are importing data from a non-Oracle hierarchical database, the corresponding "relational" construct in SQL is "START WITH ... CONNECT BY". It is documented in SQL Lang Ref Manual, or any book on SQL.

I hope I understood your question properly.

John Gasch


dinesh wrote:
>
> Does any body know an easy and efficient way of changing a
> hierarchical database ( a tree structured database) into a
> relational one.
>
> Please let me know if you do.
>
> thanks,
>
> dinesh
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Fri Mar 31 2000 - 20:35:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US