title: 使用case-when实现if-then-else逻辑
date: 2016-11-16
categories: Oracle
tags:
- Oracle
fancybox:
comments: true
permalink: 
description: 
---
```sql
--类似创建表
create table empcp  as select * from emp  where 1=1;
--1=2无数据

<!-- more -->

declare
v_emp empcp%rowtype;
begin
	select * into v_emp from empcp where ename='&雇员名';
case v_emp.job
when 'CLERK' then
    update empcp set sal=sal+500 where empno=v_emp.empno;
when 'SALESMAN' then
    update empcp set sal=sal+1000 where empno=v_emp.empno;
when 'ANALYST' then
    update empcp set sal=sal+1500 where empno=v_emp.empno;
else
    update empcp set sal=sal+2000 where empno=v_emp.empno;
end case;
commit;
end;
/
```