Top "Nvl" questions

Oracle Differences between NVL and Coalesce

Are there non obvious differences between NVL and Coalesce in Oracle? The obvious differences are that coalesce will return the …

sql oracle coalesce nvl

Oracle NVL with empty string

I have this table where NULL is the NULL value, not the string NULL: MYCOL -------- NULL example Why does …

sql oracle null nvl

Is there a function equivalent to the Oracle's NVL in MySQL?

I'm selecting the max of a column from a table. But there is one problem: if there are no rows …

mysql coalesce nvl

Select statement inside NVL

I'm trying to run the following query: select a.*, case when NVL (SELECT max(b.field1) FROM b where b.…

oracle nvl

Using NVL for multiple columns - Oracle SQL

Good morning my beloved sql wizards and sorcerers, I am wanting to substitute on 3 columns of data across 3 tables. Currently …

sql oracle coalesce nvl

How to use Oracle's decode function in where clause

I have a query with few filter criteria, one of them is get to the query as integer parameter. I …

sql oracle decode nvl

COALESCE in JPA namedQuery

I have the following namedQuery select new test.entity.Emp(COALESCE(k.projectId,'N') as projectId, k.projectName) from Emp …

java jpa coalesce toplink nvl

Why are NVL functions called "NVL"?

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

java database nvl

Oracle nvl in where clause showing strange results?

I have a web form that allows users to search on and edit records from an Oracle table based on …

oracle plsql nvl

SQL substituting NULL using NVL, having problems checking substituted value in the where clause correctly

I am running a query to display messages when the from date is before (<=) the current date and to_…

sql informix nvl