真是看着简单实操难呐[摊手]
--接收一个部门号,如果部门中员工职位是MANAGER,并且在DALLAS工作,那么就给他薪金加15%
--如果该部门员工职位是CLERK,并且在NEW YORK工作,那么久给他薪金扣除5%,其他情况不做处理
create or replace procedure update_sal_pro(v_in_deptno in number) is
v_empno emp.empno%type;
v_job emp.job%type;
v_loc dept.loc%type;
v_sal emp.sal%type;
type cursor1 is ref cursor;
my_cursor cursor1;
begin
open my_cursor for
select t2.empno,t2.job,t3.loc,t2.sal from emp t2,dept t3 where t2.deptno=t3.deptno and t2.deptno=v_in_deptno;
loop
fetch my_cursor into v_empno,v_job,v_loc,v_sal;
exit when my_cursor%NOTFOUND;
if v_job='MANAGER' and v_loc='DALLAS' then
update emp set sal = v_sal*1.15 where empno = v_empno;
elsif v_job='CLERK' and v_loc='NEW YORK' then
update emp set sal = v_sal*0.95 where empno = v_empno;
dbms_output.put_line( v_sal*0.95);
else
null;
end if;
end loop;
end;
--接收一个部门号,如果部门中员工职位是MANAGER,并且在DALLAS工作,那么就给他薪金加15%
--如果该部门员工职位是CLERK,并且在NEW YORK工作,那么久给他薪金扣除5%,其他情况不做处理
create or replace procedure update_sal_pro(v_in_deptno in number) is
v_empno emp.empno%type;
v_job emp.job%type;
v_loc dept.loc%type;
v_sal emp.sal%type;
type cursor1 is ref cursor;
my_cursor cursor1;
begin
open my_cursor for
select t2.empno,t2.job,t3.loc,t2.sal from emp t2,dept t3 where t2.deptno=t3.deptno and t2.deptno=v_in_deptno;
loop
fetch my_cursor into v_empno,v_job,v_loc,v_sal;
exit when my_cursor%NOTFOUND;
if v_job='MANAGER' and v_loc='DALLAS' then
update emp set sal = v_sal*1.15 where empno = v_empno;
elsif v_job='CLERK' and v_loc='NEW YORK' then
update emp set sal = v_sal*0.95 where empno = v_empno;
dbms_output.put_line( v_sal*0.95);
else
null;
end if;
end loop;
end;
#双十一法语词汇# - La fête des célibataires:célibataire adj. 独身的; artificiel,le a. (m) 人造的; composer v. t. 组成; promu, e a. (m) 晋级的; bouleverser v. t. 震惊; rabais n. m 减价; griffé a. (m) 缝有商标的[指衣帽等] ; traverser v. t. 穿过; peu à peu loc. adv. 逐渐地; plomber v. t. 加封
dear们https://t.cn/Ras2hO3 !!!!!走过路过千万不要错过!!!奶迪在中国的第一个生日,千载难逢的好机会,是时候放下其他的事,干点儿正事了!(看直播需会员)尽情锁定https://t.cn/Ras2hWX //t.cn/RaDJTqh!&loc=P1Z1Y1L1N1&locno=1[心][心][心][心][心][爱你]@迪玛希Dimash [爱你][鲜花][蛋糕]!!
✋热门推荐