Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

whats the difference between nullif and nvl

560656Apr 9 2007 — edited Apr 9 2007

hi,

i have a doubt in using nullif and nvl.can anybody tell me the difference.
because in some places we cant use nullif in the place of nvl.if iam right nvl is used mainly for datatype as numeric.???am i right...
if iam wrong correct me.

pls help me out..

thanks,
Ratheesh

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2007

Added on Apr 9 2007

#general-database-discussions

1 comment

407 views