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
Messages: 68
Registered: August 2007
Location: bhubaneswar
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

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: 65084
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.

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: Sun Jul 23 07:58:52 CDT 2017

Total time taken to generate the page: 0.07449 seconds