Oracle-函数Decode进行多值判断
2024-10-19 08:59:43
decode函数比较表达式和搜索字,如果匹配,返回结果;如果不匹配,返回default值;如果未定义default值,则返回空值
Decode函数的语法结构如下:
decode (expression, search_1, result_1)
decode (expression, search_1, result_1, search_2, result_2)
decode (expression, search_1, result_1, search_2, result_2, ...., search_n, result_n)
decode (expression, search_1, result_1, default)
decode (expression, search_1, result_1, search_2, result_2, default)
decode (expression, search_1, result_1, search_2, result_2, ...., search_n, result_n, default)
decode函数比较表达式和搜索字,如果匹配,返回结果;如果不匹配,返回default值;如果未定义default值,则返回空值。
以下是一个简单测试,用于说明Decode函数的用法:
SQL> create table t as select username,default_tablespace,lock_date from dba_users;
Table created.
SQL> select * from t;
USERNAME DEFAULT_TABLESPACE LOCK_DATE
------------------------------ ------------------------------ ---------
SYS SYSTEM
SYSTEM SYSTEM
OUTLN SYSTEM
CSMIG SYSTEM
SCOTT SYSTEM
EYGLE USERS
DBSNMP SYSTEM
WMSYS SYSTEM 20-OCT-04
8 rows selected. SQL> select username,decode(lock_date,null,"unlocked","locked") status from t;
USERNAME STATUS
------------------------------ --------
SYS unlocked
SYSTEM unlocked
OUTLN unlocked
CSMIG unlocked
SCOTT unlocked
EYGLE unlocked
DBSNMP unlocked
WMSYS locked
8 rows selected.
SQL> select username,decode(lock_date,null,"unlocked") status from t;
USERNAME STATUS
------------------------------ --------
SYS unlocked
SYSTEM unlocked
OUTLN unlocked
CSMIG unlocked
SCOTT unlocked
EYGLE unlocked
DBSNMP unlocked
WMSYS
8 rows selected.
文章转载http://www.jb51.net/article/36427.htm
最新文章
- iOS集成sharesdk遇到的坑
- leetcode 191
- JavaEE 获取路径全攻略
- 【LAMP】在Debian系linux下安装LAMP
- Borg Maze 分类: POJ 2015-07-27 15:28 5人阅读 评论(0) 收藏
- hdu 3367 Pseudoforest
- Color the ball----HDOJ1556
- mysql 字段注释
- java 构造方法 constructor demo笔记
- BZOJ 1047: [HAOI2007]理想的正方形( 单调队列 )
- Windows Azure入门教学系列 (八):使用Windows Azure Drive
- linux安装安卓开发工具android studio
- Nodejs之package.json介绍说明
- Redis各种数据结构性能数据对比和性能优化实践
- Mysql主从复制_模式之日志点复制
- 实例展示elasticsearch集群生态,分片以及水平扩展.
- XML 文档(1, 2)中有错误:不应有 <;xml xmlns=&#39;&#39;>;
- pip切换国内源(解决pipenv lock特别慢)
- 2018“金三”之一线互联网公司Java高级面试题总结
- NOIP考前复习-数制转换,数论模板与文件读写