NVL Function | Varinder Sandhu

Oracle – PLSQL – NVL Function

Varinder Sandhu Oracle, Oracle-Tips and Tricks, Varinder Sandhu

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

» Read more

converts, NVL Function, Oracle