Re: advanced SQL question
Date: Wed, 15 Sep 2010 17:01:48 +0200
Message-ID: <4c90dfde$0$8135$426a74cc_at_news.free.fr>
"Andreas Mosmann" <mosmann_at_expires-30-09-2010.news-group.org> a écrit dans le message de news: 1284559753.19_at_user.newsoffice.de...
| Hi Michel,
|
| thank you :)
|
| Oracle Version 11.2.0.1.0
|
| create table TKNODES (CNAME VARCHAR(10), CFROM CHAR(1), CTO CHAR(1),
| CLENGTH NUMBER(10,3))
| /
| insert into TKNODES (CNAME,CFROM,CTO,CLENGTH) values
| ('123456','O','A',10);
| insert into TKNODES (CNAME,CFROM,CTO,CLENGTH) values
| ('123456','A','B',15);
| insert into TKNODES (CNAME,CFROM,CTO,CLENGTH) values
| ('123456','B','C',10);
| insert into TKNODES (CNAME,CFROM,CTO,CLENGTH) values
| ('123456','C','O',20);
| insert into TKNODES (CNAME,CFROM,CTO,CLENGTH) values
| ('123456','B','F',50);
| insert into TKNODES (CNAME,CFROM,CTO,CLENGTH) values
| ('654321','O','A',20);
| insert into TKNODES (CNAME,CFROM,CTO,CLENGTH) values
| ('654321','A','B',30);
|
|
| --
| wenn email, dann AndreasMosmann <bei> web <punkt> de
SQL> select * from TKNODES order by cname;
CNAME C C CLENGTH
---------- - - ----------
123456 O A 10 123456 A B 15 123456 B C 10 123456 C O 20 123456 B F 50 654321 O A 20 654321 A B 30
SQL> select replace(sys_connect_by_path (cfrom, '/'), '/', '')||cto res
2 from tknodes
3 where connect_by_iscycle = 1 and cto = 'O'
4 connect by nocycle prior cname = cname and prior cto = cfrom
5 start with cfrom = 'O'
6 /
RES
OABCO Regards
Michel Received on Wed Sep 15 2010 - 10:01:48 CDT