'start with' needed outside of a 'connected by' view..

From: Jan Rosinowski <rosinowski_at_gmx.de>
Date: Mon, 30 Nov 1998 14:07:52 GMT
Message-ID: <36628685.5329162@bigXb>

i need to create a view based on a 'connected by' clause. how can i specify the 'start with' outside or simulate it?

skeleton as follows:

drop table details;
drop table implies;
/

create table details (id integer, ismain integer); create table implies(id integer, impid integer); insert into details values(1,1);
insert into details values (2,1);
insert into details values(10,0);

insert into details values (11,0);
insert into details values (100,0);
insert into details values (21,0);

insert into implies values (1,10);
insert into implies values (1,11);

insert into implies values (10,100);
insert into implies values (2,21);
/

drop view impl;
create view impl as
select * from
(
select implies.*,level l from implies start with id in ( select id from details where ismain=1) connect by id=prior impid
) union select 0 as id, details.id as impid,0 as l from details where ismain=1
/

select * from impl --start with impid=1
/

result: ID IMPID L ---------- ---------- ----------

         0          1          0
         0          2          0
         1         10          1
         1         11          1
         2         21          1
        10        100          2

... i just want the tree starting with the 1..

ciao, jan Received on Mon Nov 30 1998 - 08:07:52 CST