What is the Oracle equivalent of SQL Server's IsNull() function?

Asked 2010-08-19T14:55:49.423

146

In SQL Server we can type IsNull() to determine if a field is null. Is there an equivalent function in PL/SQL?

sql-server oracle-database t-sql plsql

Edit Report

1 Answer

144

Instead of ISNULL(), use NVL().

T-SQL:

SELECT ISNULL(SomeNullableField, 'If null, this value') FROM SomeTable

PL/SQL:

SELECT NVL(SomeNullableField, 'If null, this value') FROM SomeTable

answered 2010-08-19T15:00:26.197