DECODE
decode(condition,x1, y1, x2, y2, x3,y3 [,xn, yn] ……, default_value)
The meaning of the function is as follows.
IF condition=x1 THEN
RETURN(y1)
ELSIF condition=x2 THEN
RETURN(y2)
......
ELSIF condition=xn THEN
RETURN(yn)
ELSE
RETURN(default_value)
END IF
Example:
select EMPNO, decode(DEPTNO, 10, 1, 20, 2, 30,3, 0) from emp;
EMPNO | DECODE(DEPTNO, 10, 1, 20, 2, 30,3, 0)
-------+----------------------------------------
7521 | 3
7566 | 2
7654 | 3
7782 | 1
7788 | 2
7839 | 1
7844 | 3
7900 | 3
7902 | 2
7934 | 1
7876 | 2
7469 | 2
7698 | 3
7369 | 2
7499 | 3
(15 rows)
Top comments (0)