2013年
-
编辑 删除
NVL2函数
文档地址：http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions106.htm#SQLRF00685 NVL2 Syntax Description of the illustration nvl2.gif Purpose NVL2 lets you determine the value returned by a query based on whether a specified expression is null or not null. If expr1 is not null, then NVL2 returns expr2. If expr1 is null, then NVL2 returns expr3.--函数作用 The argument expr1 can have any datatype. The arguments expr2 and expr3 can have any datatypes except LO
