Re: Hierarches
From: DanHW <danhw_at_aol.com>
Date: 16 Oct 1998 03:33:33 GMT
Message-ID: <19981015233333.09710.00001094_at_ng72.aol.com>
Date: 16 Oct 1998 03:33:33 GMT
Message-ID: <19981015233333.09710.00001094_at_ng72.aol.com>
>Question: Does anyone out there know how to set up a hierarchy in ORACLE?
>What I am trying to do is create a hierarchy which could, in theory, go on
>infinitely between parent and children. Any help is appreciated greatly.
>Thanks.
>-Mike-
>
>
Use the CONNECT BY structure. It is documented in the help; but better in some
3rd party books. That structure works, but has its limitations.
Good Luck
Dan Hekimian-Williams
Received on Fri Oct 16 1998 - 05:33:33 CEST