IS NOT NULL is a comparison that evaluates to TRUE if the expression is not a null value. You can use the IS NOT NULL condition in either a SQL statement or in a block of PLSQL code.
ref: http://www.techonthenet.com/oracle/isnotnull.php
ref: http://www.techonthenet.com/oracle/isnotnull.php
I have a small doubt.
ReplyDeleteIS NOT NULL
=NULL
='NULL'
are they give same results?