Results 1 to 2 of 2

Thread: NVL - what if you dont use it?

  1. #1
    Join Date
    Oct 2006
    Location
    Denver
    Posts
    4

    NVL - what if you dont use it?

    I have a varchar2 column that has nulls in it. Is it absolutly neccessary to use nvl whenever I do a select with a where clause using that field? If I could please get an explaination of what the bad affects would be if I didn't? Thanks!!

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    In Oracle NULL is not equal to NULL, everytime you compare something with a column you need to convert it to something so that you do not get unexpected result.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •