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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL Query

Re: SQL Query

From: Mahmoud Reza Zare <mrezair_at_0racledba.com>
Date: Mon, 2 Oct 2000 22:42:34 -0700 (PDT)
Message-Id: <10637.118360@fatcity.com>


You should break your SELECT in two parts , sth like this

select TES.TEST_ID, me.ANALYTE, me.value from (select ANA.ANALYTE, nvl(TO_CHAR(NOR.Value),'NULL') Value, ana.test_id, nor.ns_id from NORMS NOR, ANALYTES ANA
 WHERE NOR.ANALYTE(+)=ANA.ANALYTE) me, test tes where tes.TEST_ID = me.TEST_ID
and me.NS_ID=TES.NS_ID
AND TES.test_id= 1

Further you may optimize it to

select TES.TEST_ID, me.ANALYTE, me.value from (select ANA.ANALYTE, nvl(TO_CHAR(NOR.Value),'NULL') Value, ana.test_id, nor.ns_id from NORMS NOR, ANALYTES ANA
 WHERE NOR.ANALYTE(+)=ANA.ANALYTE
      and ana_tes_id (+) = 1 ) me, test tes where tes.TES.TEST_ID = me.TEST_ID
and me.NS_ID=TES.NS_ID


Be someone_at_0racledba.com - get your free mail from Oriole Corporation  http://www.oriolecorp.com - Performance tools for Oracle DBAs Received on Tue Oct 03 2000 - 00:42:34 CDT

Original text of this message

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