[Oracle] DECODE函数
时间:2022-03-14 02:25
SELECT DEPTNO , DEcode(DEPTNO, 10, ‘会计‘, 20, ‘研发‘, 30, ‘销售‘, ‘运营‘) 部门 , DNAME , LOC FROM DEPT;
时间:2022-03-14 02:25
SELECT DEPTNO , DEcode(DEPTNO, 10, ‘会计‘, 20, ‘研发‘, 30, ‘销售‘, ‘运营‘) 部门 , DNAME , LOC FROM DEPT;