Examples for the usage of Oracle/PLSQL's NVL() function for substitution of NULL values

nvl_plsql_oracle_examples.sql

# ORACLE/PLSQL - NVL(A, B) EXAMPLES
# If A IS NULL substitute with B

# Example 1. if table b contains values that over-write values in table a

SELECT NVL(b.name, a.name) AS name FROM a left join b on a.id = b.id;

# Example 2. to replace NULL values with an alternative placeholder value

SELECT NVL(a.name, 'Unnamed') AS name FROM a;

Gracias!