点击(此处)折叠或打开
-
NVL2(expr1,expr2,expr3)
-
-
功能：如果参数表达式expr1值为NULL，则NVL2()函数返回参数表达式expr3的值；如果参数表达式expr1值不为NULL，则NVL2()函数返回参数表达式expr2的值。
- expr2 和 expr3的类型必须保持一致，expr1的类型不用管。
-
-
NVL( string1, replace_with)
-
- 功能：如果string1为NULL，则NVL函数返回replace_with的值，否则返回string1的值，如果两个参数都为NULL ，则返回NULL。
- string1和replace_with的类型必须保持一致
点击(此处)折叠或打开
-
SQL> select nvl2(sysdate,'sysdate+1','dfdf') from dual;
-
-
NVL2(SYSD
-
---------
-
sysdate+1
-
-
SQL> select nvl2(sysdate,sysdate+1,'dfdf') from dual;
-
select nvl2(sysdate,sysdate+1,'dfdf') from dual
-
*
-
ERROR at line 1:
- ORA-01858: a non-numeric character was found where a numeric was expected
点击(此处)折叠或打开
-
SQL> select nvl(sysdate,sysdate+1) from dual;
-
-
NVL(SYSDATE,
-
------------
-
04-AUG-16
-
-
SQL> select nvl(sysdate,'sysdate+1') from dual;
-
select nvl(sysdate,'sysdate+1') from dual
-
*
-
ERROR at line 1:
-
ORA-01858: a non-numeric character was found where a numeric was expected
-
-
-
SQL> select nvl(111,'sysdate+1') from dual;
-
select nvl(111,'sysdate+1') from dual
-
*
-
ERROR at line 1:
-
ORA-01722: invalid number
-
-
-
SQL> select nvl('dfdf','sysdate+1') from dual;
-
-
NVL(
-
----
- dfdf
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28551528/viewspace-2122987/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 不可见索引 invisible
- Oracle11g DataGuard Broker配置
- Real-Time apply异常，求解
- 查看表中某列的low_value和high_value
- inner、left/right、full outer、natural、union
- ORA-12537 dblink
- 11gR1 11gR2 compress 与compress for oltp
- alter table xx move tablespace xx update indexes faild with ORA-14327
- 查询字符类型转换date类型后值的函数
- OCP知识点讲解 之 什么是Buffer Cache？
