Re: advanced SQL question

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