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 -> Re: Oracle Sub Query "not in" problem

Re: Oracle Sub Query "not in" problem

From: Wazusa Blong <fitzjarrell_at_cox.net>
Date: Fri, 08 Jun 2007 06:13:28 -0700
Message-ID: <1181308408.359094.241370@p47g2000hsd.googlegroups.com>


On Jun 8, 4:40 am, "Shakespeare" <what..._at_xs4all.nl> wrote:
> <Amritha.Da..._at_gmail.com> schreef in berichtnews:1181161552.973055.222230_at_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
>
> I think you got an answer to this two days ago......- Hide quoted text -
>
> - Show quoted text -

He did. It's too bad he can't accept what has already been told to him.

David Fitzjarrell Received on Fri Jun 08 2007 - 08:13:28 CDT

Original text of this message

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