Why are NVL functions called "NVL"?

java database nvl
c0rp picture c0rp · Mar 9, 2015 · Viewed 17.6k times · Source

Sometimes I see an nvl() function in code. In the case of Java, it looks like this:

public static String nvl(String value, String alternateValue) {
    if (value == null)
        return alternateValue;

    return value;
}

I understand what this function does, but I don't understand why it's called nvl. Why not checkNotNull or returnNotNull? What does NVL stand for?

I guess Null Value L...?

Answer

Atsby picture Atsby · Mar 9, 2015

As others have pointed out in comments, it probably stands for "null value" or "null value logic". It might just as well be called "dflt" (or similar abbreviation) for "default".

And, in Java, it should really be using generics so that it can work on any type ;)

Related questions

How do I find out my MySQL URL, host, port and username?

I need to find my MySQL username. When I open the MySQL command line client, it only asks me for my password. I don't remember my username. And for connectivity with JDBC, I need the URL, host and port number. …

Read More
What is the easiest way to ignore a JPA field during persistence?

I'm essentially looking for a "@Ignore" type annotation with which I can stop a particular field from being persisted. How can this be achieved?

Read More
Is it possible to specify the schema when connecting to postgres with JDBC?

Is it possible? Can i specify it on the connection URL? How to do that?

Read More