Re: hierarchical tree
From: Jan Schäfer <jan.schaefer_at_kksl.uni-leipzig.de>
Date: Fri, 14 Jun 2002 10:22:32 +0200
Message-ID: <3D09A7C8.6010402_at_kksl.uni-leipzig.de>
Date: Fri, 14 Jun 2002 10:22:32 +0200
Message-ID: <3D09A7C8.6010402_at_kksl.uni-leipzig.de>
> However it is not posssible to create a "dummy"-entry, so that comp1 has a
> parent-entry!!!
> Has somebody an idea to realize this with an sql-Statement?
[Quoted] Just try to do an union:
select decode (level, 1, 1, 1),LEVEL, lower_comp, NULL, lower_comp
from composition
start with upper_comp = 'comp1'
connect by prior lower_comp = upper_comp
union
select dummy_value, dummy_value, dummy_value, dummy_value, dummy_value
from dual
So long,
Jan Received on Fri Jun 14 2002 - 10:22:32 CEST