SQL Server 改为ORACLE的语法 - Oracle / 开发

select ID as '部门编号', Department as '部门名称', 
  [正式] = Sum ( case when EmployeeType = ' 正式 ' then Cnt else 0 end ),
  [临时] = Sum ( case when EmployeeType = ' 临时 ' then Cnt else 0 end ), 
  [辞退] = Sum ( case when EmployeeType = ' 辞退 ' then Cnt else 0 end ),
  [合计] = Sum ( case when EmployeeType <> '' then Cnt else 0 end ) 
from VDepartmentEmployeeType group by ID, Department

上面的sql是sqlserver的，是个表的行列转换
[正式] = Sum (...)，改成oracle应该怎么写呢？

---

select ID as '部门编号', Department as '部门名称', 
  Sum ( case when EmployeeType = ' 正式 ' then Cnt else 0 end ) 正式,
  Sum ( case when EmployeeType = ' 临时 ' then Cnt else 0 end ) 临时 , 
  Sum ( case when EmployeeType = ' 辞退 ' then Cnt else 0 end ) 辞退,
  Sum ( case when EmployeeType <> '' then Cnt else 0 end ) 合计 
from VDepartmentEmployeeType group by ID, Department

---

这个
SQL code:
select ID 部门编号, Department 部门名称,
Sum ( case when EmployeeType = ' 正式 ' then Cnt else 0 end ) 正式,
Sum ( case when EmployeeType = ' 临时 ' then Cnt else 0 end ) 临时 ,
Sum ( case when EmployeeType = ' 辞退 ' then Cnt else 0 end ) 辞退,
Sum ( case when EmployeeType <> '' then Cnt else 0 end