Home » SQL & PL/SQL » SQL & PL/SQL » why <> null is not equal to is not null?
why <> null is not equal to is not null? [message #215504] Mon, 22 January 2007 11:02 Go to next message
Smith_X
Messages: 56
Registered: January 2007
Member
Hello quick question please...

I use both <> null and != null in my code and it's seem those are not working..

finally, I have to guess that I should use is not null instead.

why ??

Regards,
Re: why <> null is not equal to is not null? [message #215545 is a reply to message #215504] Mon, 22 January 2007 18:07 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/schema.htm#sthref725
Re: why <> null is not equal to is not null? [message #215640 is a reply to message #215545] Tue, 23 January 2007 05:31 Go to previous message
Smith_X
Messages: 56
Registered: January 2007
Member
Thank you very much, rleishman.

now I knew I should strict with is null or is not null instead of <> null.

Thanks again Cool
Previous Topic: Needed a simplified sql querry
Next Topic: Oracle 10g Express Edition - Starting
Goto Forum:
  


Current Time: Tue Dec 06 15:44:24 CST 2016

Total time taken to generate the page: 0.17566 seconds