我一开始看以为很简单,不过只能用一句sql的话就有点意思,我写了一条plsql可以实现,不知道符不符合楼主一条sql的要求
declare
v1 varchar2(10);
v2 varchar2(10);
cursor ss is
select deptno,city into v1,v2 from dept ;
begin
open ss ;
while true
loop
fetch ss into v1,v2;
exit when ss%notfound;
if v2='成都'then
update emp set sal=sal*1.3 where deptno =v1 ;
else
update emp set sal=sal*1.2 where deptno =v1;
end if;
end loop;
end;
declare
v1 varchar2(10);
v2 varchar2(10);
cursor ss is
select deptno,city into v1,v2 from dept ;
begin
open ss ;
while true
loop
fetch ss into v1,v2;
exit when ss%notfound;
if v2='成都'then
update emp set sal=sal*1.3 where deptno =v1 ;
else
update emp set sal=sal*1.2 where deptno =v1;
end if;
end loop;
end;