-
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!!
-
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
-
Forum Rules
|
|