| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Hierachical structures - an overview
Lennart Jonsson wrote:
>
> "Mike MacSween" <mike.macsween.nospam_at_btinternet.com> wrote in message news:<3ff7e63a$0$52881$5a6aecb4_at_news.aaisp.net.uk>...
> > I have an app I need a hierachical structure for. There seem to be 3 ways of
> > implementing this, as far as I can see:
> >
> ....
> > Any other techniques?
> >
>
> Recursive SQL. It is supported by atleast two databases, DB2 (WITH)
> and Oracle (CONNECT BY).
Recursive SQL is also supported by FirstSQL/J (see my sig). It uses an Oracle-like CONNECT BY syntax.
-- Lee Fesperman, FirstSQL, Inc. (http://www.firstsql.com) ============================================================== * The Ultimate DBMS is here! * FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)Received on Sun Jan 04 2004 - 20:19:33 CST
![]() |
![]() |