declare
bsal number;
bhour number;
times varchar(2);
cursor empcur is
select * from emp e1 where emp_A>=100 and emp_A <=200 and emp_current_data='T' and
emp_times=(select max(emp_times) from emp e2 where e1.emp_id=e2.emp_id)
and emp_indate< to_date('01-3月-10');
begin
for emp_val in empcur
loop
select max(emp_times) into times from emp where emp_idno=emp_val.emp_idno;
times :=times+1;
A:=emp_val.emp_A+50;
B:=round(A/21.75/8,2);
update emp set emp_current_data='F' where emp_times=emp_val.emp_times and emp_id=emp_val.emp_id;
insert into emp ( ..................) values(.......................);
---省略无关细节
end loop;
end;
/
--功能,在原记录基础上复制一条记录,并修改部分字段内容
pl/sql
最新推荐文章于 2024-08-12 10:43:45 发布