Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: "start with" non using index

Re: "start with" non using index

From: news.onet.pl <marcin.buchwald_at_poczta.onet.pl>
Date: Mon, 4 Dec 2006 16:23:24 +0100
Message-ID: <el1ehj$idg$1@news.onet.pl>


It helps, but it is not exactly what you need:

select t.mak_xx,t.nr_porz,level lvl from (select s.mak_xx,s.nr_porz,s.derv_mak_xx,s.derv_nr_porz,s.dervlvl from spacer_strona s,makieta m,makieta m2 where m2.xx=125414 and m.kiedy=m2.kiedy and s.mak_xx=m.xx) t start with t.mak_xx=125414 and t.nr_porz=0 connect by t.mak_xx = prior t.derv_mak_xx and t.nr_porz = prior t.derv_nr_porz and prior t.dervlvl=3 Received on Mon Dec 04 2006 - 09:23:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US