DECODE()函数,它将输入数值与函数中的参数列表相比较,根据输入值返回一个对应值。函数的参数列表是由若干数值及其对应结果值组成的若干序偶形式。当然,如果未能与任何一个实参序偶匹配成功,则函数也有默认的返回值。
语法结构如下:
decode (expression, search_1, result_1) decode (expr ession, search_1, result_1, search_2, result_2) decode (expr ession, search_1, result_1, search_2, result_2, ...., search_n, result_n) decode (expr ession, search_1, result_1, default) decode (expr ession, search_1, result_1, search_2, result_2, default) decode (expr ession, search_1, result_1, search_2, result_2, ...., search_n, result_n, default)
比较表达式和搜索字,如果匹配,返回结果;如果不匹配,返回default值;如果未定义default值,则返回空值。
select taskid, dtypename, (select deptname from T_DEPTINFO where deptno=t1.deptno) deptno,
decode(analyunit,1,'五分钟',2,'六分钟',3,'十分钟',4,'小时',5,'天',analyunit) analyunit,
decode(alarmbz,1,'启用',2,'不启用',alarmbz) alarmbz, alarminfo,
decode(ifsendsms,1,'通知',2,'不通知') ifsendsms, alarmsts, mobilenostr, memo from T_DTYPECOUNTCFG t1
where rsts=1 order by alarmsts desc,deptno,rsts desc,alarmbz desc,orderby;
select t.deptno,t.deptname,t.keyid ,
decode(orderby ,1,'一',0) orderby
from T_DEPTINFO t;
select t.deptno,t.deptname,t.keyid ,
decode(orderby ,1,'一',2,'二',5,'五',8,'八',4,'四',7,'七',3,'三',6,'六',99,'九九') orderby
from T_DEPTINFO t;
select * from T_DEPTINFO t;