ple recipients of list ORACLE-L
btw, a straight not in without a hash_aj, tends to get hideous bench marks.
>
> From: Mladen Gogala <[EMAIL PROTECTED]>
> Date: 2003/12/18 Thu AM 09:14:24 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Any know
elative to the inner query, minus tends to be the best.
These are broad generalizations, but work well and are MUCH better than just guessing.
>
> From: Mladen Gogala <[EMAIL PROTECTED]>
> Date: 2003/12/18 Thu AM 09:14:24 EST
> To: Multiple recipients of list ORACLE-L <
btw, a straight not in without a hash_aj, tends to get hideous bench marks.
>
> From: Mladen Gogala <[EMAIL PROTECTED]>
> Date: 2003/12/18 Thu AM 09:14:24 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Any known problems using NOT
e NOT EXISTS clause, unless you
> are sure that the inner query will not return any NULLs.
>
> Regards,
> Charu.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Siddharth Haldankar
> Sent: 18 December 2003 10:54
>
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Naveen,
Nahata (IE10)
Sent: Thursday, December 18, 2003
11:59 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Any known problems
using NOT IN ?
Doess the column crs.os_id_fk1 contain nulls?
Regards
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Charu
Joshi
Sent: Thursday, December 18, 2003
11:09 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Any known problems
using NOT IN ?
Siddharth,
The NOT IN query fails to return rows, if
the inner sub-query returns
Doess the column crs.os_id_fk1 contain nulls?
Regards
Naveen
-Original Message-From: Siddharth Haldankar
[mailto:[EMAIL PROTECTED]Sent: Thursday, December 18, 2003 10:54
AMTo: Multiple recipients of list ORACLE-LSubject: Any
known problems using NOT IN ?
Hi
Gurus
]
[mailto:[EMAIL PROTECTED]On Behalf Of Siddharth
HaldankarSent: 18 December 2003 10:54To: Multiple
recipients of list ORACLE-LSubject: Any known problems using NOT IN
?
Hi
Gurus,
I have a problem
using NOT IN clause in Oracle. However using NOT EXISTS, gives me the right
Hi Gurus,
I have a problem
using NOT IN clause in Oracle. However using NOT EXISTS, gives me the right
output. Are there any known limitations.
This query selects
from the master records wherein child records are not active.
select * from ct_software_release
csr where
csr.cl