NVL in Oracle's SQL allows you to substitute a value if the main value in null.

This has this example:

SELECT NVL(supplier_city, 'n/a')
FROM suppliers;