Home » SQL & PL/SQL » SQL & PL/SQL » funda of NULL
funda of NULL [message #301691] Thu, 21 February 2008 06:48 Go to next message
gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar
Member
Hi Experts,

Please show the below query
select * from dual where 123 not in(select null from dual);


And please explain me why here output is coming as no rows selected?

Thanks and Regards
Sunil


Re: funda of NULL [message #301695 is a reply to message #301691] Thu, 21 February 2008 07:02 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"x not in (null)" is equivalent to "x != null" which is never true as nothing is equal or not equal to null.

Regards
Michel
Previous Topic: Problem to run store procedure - ORA-01008: not all variables bound
Next Topic: MERGE statement and primary key constraint violation
Goto Forum:
  


Current Time: Wed Dec 07 07:07:30 CST 2016

Total time taken to generate the page: 0.10786 seconds