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

Home -> Community -> Usenet -> c.d.o.tools -> Oracle Sub Query "not in" problem

Oracle Sub Query "not in" problem

From: <Amritha.Datta_at_gmail.com>
Date: 8 Jun 2007 02:20:06 -0700
Message-ID: <1181161552.973055.222230@q19g2000prn.googlegroups.com>


Is there any alternative query to the below one?

update RTable set Reason = "XYZ"

            Where FKey = 1234
                and SFKey = 1
                and Reason Is Null
                and F_ID  not in ( Select F_ID from RTable
                                    Where FKey = 1234
                                    and SFKey = 1
                                    and TO_NUMBER(REL_CD) = 1
                                    and Reason Is Null);

"not in" in the above query is taking alot of time and it is timing out.

Please Advise.

Thanks Received on Fri Jun 08 2007 - 04:20:06 CDT

Original text of this message

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