Null in C is Nothing or Void which can be compared with normal operators but inoracle Null can't be compared with normal operators like '=' or greater than or smallerthan.so be careful in using this feature of oracle because it can lead to several problems as like if u compared a password with oracle internal password and a user supplies a nullin password ur comparison may false like if INPUT_PASSWORD<>ORIGINAL_PASSWORD then raise_application_error(-20225,'"Incorrect Password");
NULL in SQL in an unknown value. It neither zero nor any valid value. It cannot be mapulated, but it can only be compared.
SOURCE : www.referjava.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment