Last updated 1 year ago
Replaces NULL with the specified replacement value. ().
ISNULL ( check_expression , replacement_value )
NVL( <expr1> , <expr2> )
Code:
SELECT ISNULL(NULL, 'SNOWFLAKE') AS COMPANYNAME;
Result:
+-----------+ |COMPANYNAME| +-----------+ |SNOWFLAKE | +-----------+
SELECT NVL(NULL, 'SNOWFLAKE') AS COMPANYNAME;