START WITH and CONNECT BY clause
From: Elton Chan <97980015r_at_polyu.edu.hk>
Date: 1998/06/17
Message-ID: <6m83d0$1ut2_at_hkpa05.polyu.edu.hk>#1/1
Date: 1998/06/17
Message-ID: <6m83d0$1ut2_at_hkpa05.polyu.edu.hk>#1/1
Hi all,
[Quoted] [Quoted] 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?
[Quoted] 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 CEST