The CASE expression was first added to SQL in Oracle 8i. ... SELECT ename, empno, deptno, (CASE deptno WHEN 10 THEN 'Accounting' WHEN 20 THEN 'Research' ...
確定! 回上一頁