![]() value_if_null (mandatory): If value_to_check is null, then NVL2 returns this value.value_if_not_null (mandatory): If value_to_check is not null, then NVL2 returns this value.value_to_check (mandatory): This is the value to check to see if it is NULL or not.The syntax of the Oracle NVL2 function is: NVL2( value_to_check, value_if_not_null, value_if_null ) ![]() Oracle NVL2 Function Syntax and Parameters The ISNULL function returns the replace_value if the input_value is NULL, and returns input_value if it is not NULL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |