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

Home -> Community -> Usenet -> c.d.o.server -> START WITH and CONNECT BY clause

START WITH and CONNECT BY clause

From: Elton Chan <97980015r_at_polyu.edu.hk>
Date: 1998/06/17
Message-ID: <6m83d0$1ut2@hkpa05.polyu.edu.hk>#1/1 







Hi all,



    Anybody can tell if the "start with" and "connect by" clause to select
rows in a hierarchical order is valid for single table or multiple table?



    Hence, if I have multiple tables and have some hierarchical relations
among each tables, and I  would like to navigate within the tables to find
the child and parent, can I use the start with and connect by? Or all the
hierarchical information must be placed in the same table??



Please help.



Elton
Received on Wed Jun 17 1998 - 00:00:00 CDT












Original text of this message













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