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!!
Printable View
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!!
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.