Oracle与SQL Server的IsNull()函数等效吗? [英] What is the Oracle equivalent of SQL Server's IsNull() function?

问题描述

在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，并且与nvl和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.)

这篇关于Oracle与SQL Server的IsNull()函数等效吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！