使用Oracle的Decode函数进行多值判断
时间:2024-01-28 09:12:54
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.
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
使用OpenCV为图像加水印的教程
![](https://img.aspxhome.com/file/2023/8/134968_0s.jpg)
python3 实现自定义切片类为左闭右闭详情
10个python爬虫入门实例(小结)
深入理解Go语言中的数组和切片
Keras中的多分类损失函数用法categorical_crossentropy
![](https://img.aspxhome.com/file/2023/5/63935_0s.jpg)
分享Pytest fixture参数传递的几种方式
利用Python程序读取Excel创建折线图
![](https://img.aspxhome.com/file/2023/9/85219_0s.png)
几个javascript显示加载进度条代码
python+matplotlib演示电偶极子实例代码
![](https://img.aspxhome.com/file/2023/3/77673_0s.jpg)
python数字图像处理之基本图形的绘制
![](https://img.aspxhome.com/file/2023/8/121498_0s.png)
Git的简单理解及基础操作命令详解
Python 函数list&read&seek详解
![](https://img.aspxhome.com/file/2023/7/86447_0s.png)
python读取xml文件方法解析
JS实现十字坐标跟随鼠标效果
![](https://img.aspxhome.com/file/2023/9/135569_0s.jpg)
Java使用JDBC连接数据库的实现方法
教你利用Selenium+python自动化来解决pip使用异常
![](https://img.aspxhome.com/file/2023/0/110200_0s.png)
sqlplus登录\\连接命令、sqlplus命令的使用大全
如何将JSP/Servlet项目转换为Spring Boot项目
![](https://img.aspxhome.com/file/2023/3/97883_0s.png)