What is the Oracle equivalent of SQL Server s IsNull function

Question

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

Answer 1

The functionality of coalesce, which is supported by both Oracle and SQL Server, is quite similar to that of nvl and isnull. (There are several significant differences, and coalesce only returns the first parameter that is not null.) On SQL Server at least, the return type for isnull matches the type of the first parameter, but not the case for coalesce.)

I hope this helps you.