Oracle Documentation NOT NVL

If param1 is NOT (NULL or EMPTY STRING) it returns param2 else returns param3.

You could write:

NVL2(loves_marmite, 'Nope', something_else)

Also, see this answer for a list of null-related functions in Oracle

sql sql-server oracle

First, please see the isNull function. But Oracle may be trying to tell you to replace the NVL funcionality with a case;

SELECT CASE WHEN Foo IS NOT NULL THEN bar                                 ELSE BLA             END

CodeHunter