NVL(, -1) oracle code example Example: oracle nvl2 NVL2( string_to_test, value_if_NOT_null, value_if_null )