RE: Query

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Thu, 17 Aug 2000 16:24:40 +0400
Message-Id: <10592.114822@fatcity.com>

Hi,
this query:

	select * from dual
	where dummy not in ( select 'a' from dual union select '' from

dual);
where clause means:

             dummy != 'a' and dummy != null
since comparision against a null results in a null, the complete expression fails.
Care should be taken where subqueries are returning null.

Thanks,
Amar
050-7883254(Dubai)
ts2017_at_emirates.com
amar_padhi_at_hotmail.com

-----Original Message-----
From: Tripathi Amit [mailto:Amit.Tripathi_at_sisl.co.in] Sent: Thursday, August 17, 2000 4:06 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Query

Try this
select * from dual where dummy not in
( select 'a' from dual union select nvl('',0) from dual)

	-----Original Message-----
	From:	Rustem Valeev [SMTP:valeev_at_avicomp.ru]
	Sent:	Thursday, August 17, 2000 12:44 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Query

	Why this query don't work:

	select * from dual
	where dummy not in ( select 'a' from dual union select '' from dual)

	That's simplified version from real work.
	--
	Rustem Valeev, valeev_at_avicomp.ru, (095)4360496


	-- 
	Author: Rustem Valeev
	  INET: valeev_at_avicomp.ru

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L
	(or the name of mailing list you want to be removed from).  You may
	also send the HELP command for other information (like subscribing).

-- 
Author: Tripathi Amit
  INET: Amit.Tripathi_at_sisl.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Aug 17 2000 - 07:24:40 CDT