OraFAQ Forum: SQL & PL/SQL » why <> null is not equal to is not null?

Home » SQL & PL/SQL » SQL & PL/SQL » why <> null is not equal to is not null?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

why <> null is not equal to is not null? [message #215504]

Mon, 22 January 2007 11:02

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,

Report message to a moderator

Re: why <> null is not equal to is not null? [message #215545 is a reply to message #215504]

Mon, 22 January 2007 18:07

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/schema.htm#sthref725

Report message to a moderator

Re: why <> null is not equal to is not null? [message #215640 is a reply to message #215545]

Tue, 23 January 2007 05:31

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

Report message to a moderator

Previous Topic:	Needed a simplified sql querry
Next Topic:	Oracle 10g Express Edition - Starting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 19:16:22 CST 2024