Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2011
    Posts
    1

    Question Unanswered: NVL Function problem

    Hello. I have been trying to decrypt a series of reports that I inherited for an Oracle databse. They were created a couple of years ago, and for the most part are rather straightforward, if somewhat Byzantine in their structure.

    However, I've stumbled upon this line of code, and I can't decipher what the original coder intended it for:

    SELECT
    NVL(NVL(COUNT_USERS,0),0),

    It would appear the idea is to replace Null values in COUNT_USERS with 0. But if that is the case, wouldn't it be easier to simply do NVL(COUNT_USERS,0), ? Why nest it like that? What am I missing?

    Hope somebody can help.

    C

  2. #2
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    I don't think you are missing anything other than a mistake in the original code as the inner nvl will never be null
    There are 10 types of people in the world, those that know Binary and those that don't.

Tags for this Thread

Posting Permissions

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