与 SQL Server 的 IsNull() 函数等效的 Oracle 是什么?

2021-12-06 00:00:00 tsql oracle sql-server plsql

在 SQL Server 中,我们可以键入 IsNull() 来确定字段是否为空.PL/SQL 中是否有等价的函数?

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

推荐答案

coalesce 在 Oracle 和 SQL Server 中均受支持,其功能与 nvlnvl 基本相同代码>isnull.(有一些重要的区别,coalesce 可以接受任意数量的参数,并返回第一个非空的.isnull 的返回类型与第一个的类型匹配论点,对于 coalesce 来说不是这样,至少在 SQL Server 上是这样.)

coalesce is supported in both Oracle and SQL Server and serves essentially the same function as nvl and isnull. (There are some important differences, coalesce can take an arbitrary number of arguments, and returns the first non-null one. The return type for isnull matches the type of the first argument, that is not true for coalesce, at least on SQL Server.)

相关文章