CASE()函数

CASE()函数使用嵌入的表达式确定返回值，其语法如下：

CASE
When condition1 Then result1
When condition2 Then result2
...
When conditionN Then resultN
Else default_result
End

上例子：

SQL> Select ename, depno,
Case depno
When 10 Then 'ACCOUNTING'
When 20 Then 'RESEARCH'
When 30 Then 'SALES'
Else 'NOT EXISTS'
End
From emp;

ENAME      DEPTNO      CASEDEPTNO
----------     -------------  ---------------------
SMITH        20               RESEARCH
ALLEN        30               SALES
...
MARY         20               RESEARCH
CLARK        10               ACCOUNTING