"Not in" subquery

#1

Hello,

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

#2

On Jun 6, 3:23 pm, Amritha.Da... (AT) gmail (DOT) com wrote:

Quote:

Hello,

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

Cross-posting doesn't help you get a faster response.

David Fitzjarrell

#3

On Jun 6, 4:44 pm, fitzjarr... (AT) cox (DOT) net wrote:

Quote:

On Jun 6, 3:23 pm, Amritha.Da... (AT) gmail (DOT) com wrote:

Hello,

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

Cross-posting doesn't help you get a faster response.

David Fitzjarrell

Sorry. Please help me as it is urgent requirement.

Sorry again!

Thanks

#4

On Jun 6, 3:46 pm, Amritha.Da... (AT) gmail (DOT) com wrote:

Quote:

On Jun 6, 4:44 pm, fitzjarr... (AT) cox (DOT) net wrote:

On Jun 6, 3:23 pm, Amritha.Da... (AT) gmail (DOT) com wrote:

Hello,

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

Cross-posting doesn't help you get a faster response.

David Fitzjarrell

Sorry. Please help me as it is urgent requirement.

Sorry again!

Thanks- Hide quoted text -

- Show quoted text -

"Urgent" is not a newsgroup mantra. If this truly IS 'urgent'
possibly you should pay a consultant to work on this on-site.

David Fitzjarrell

#5

On Jun 6, 4:58 pm, fitzjarr... (AT) cox (DOT) net wrote:

Quote:

On Jun 6, 3:46 pm, Amritha.Da... (AT) gmail (DOT) com wrote:

On Jun 6, 4:44 pm, fitzjarr... (AT) cox (DOT) net wrote:

On Jun 6, 3:23 pm, Amritha.Da... (AT) gmail (DOT) com wrote:

Hello,

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

Cross-posting doesn't help you get a faster response.

David Fitzjarrell

Sorry. Please help me as it is urgent requirement.

Sorry again!

Thanks- Hide quoted text -

- Show quoted text -

"Urgent" is not a newsgroup mantra. If this truly IS 'urgent'
possibly you should pay a consultant to work on this on-site.

David Fitzjarrell

Ok. My apologies!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

"Not in" subquery

comp.databases.oracle.tools comp.databases.oracle.tools

"Not in" subquery - 06-06-2007 , 03:23 PM

Re: "Not in" subquery - 06-06-2007 , 03:44 PM

Re: "Not in" subquery - 06-06-2007 , 03:46 PM

Re: "Not in" subquery - 06-06-2007 , 03:58 PM

Re: "Not in" subquery - 06-06-2007 , 04:11 PM