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).