Oracle – PLSQL – NVL Function
NVL lets you replace null with a string in the results of a query. Syntax NVL (string1, replace_with) If string1 is null, then NVL returns replace_with. If string1 is not null, then NVL returns string1. Note: The arguments string1and replace_with can have any data type. If their data types are different, then Oracle Database implicitly converts one to the other. If they are cannot be converted implicitly, the database returns an error.
» Read more