BOLL Calendar 

with Matylda Wielgosz, Angelika Wachowska, Agnieszka Westfal, Patrycja Banaś, Monika Podhajecka, Paulina Guzinska, Anna Adamska

MUA: Katarzyna Brzezińska

Hair: Patryk Nadolny

Assist: Tomek Dębski, Mikołaj Chocieszyński

Loc: Studio Tęcza

转载[酷][酷][酷]
#厦门[超话]##我的生活##商业摄影##厦门摄影师##时尚摄影#

"So sorry mum and dad. The route to abroad didn't succeed. Mum. I love you and dad so much. I am dying because I can't breathe. I am from Can Loc Ha Tinh. Vietnam. Mum. I'm very sorry." 读起来太难受了，谁无父母，“妈妈，爸爸，太对不起了。去国外的路线，没走成。妈妈，我很爱你和爸爸。我现在快要死了，因为没法呼吸。我来自越南河静省的干禄县。妈妈，对不起。”

真是看着简单实操难呐[摊手]
--接收一个部门号，如果部门中员工职位是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;