v_max_id number;
BEGIN
--将表中主键的最大值找出赋给v_max_id
select max(deptno) into v_max_id from dept;
--对数据表进行操作
insert into dept values(v_max_id+10,'HR','CHINA');
for i in (select deptno from dept where deptno >='50') loop
delete from DEPT where deptno = i.deptno;
-- dbms_output.put_line(i.deptno);
end loop;
END;
v_max_id number;
BEGIN
--将表中主键的最大值找出赋给v_max_id
select max(deptno) into v_max_id from dept;
--对数据表进行操作
insert into dept values(v_max_id+10,'HR','CHINA');
for i in 50..90 loop
delete from DEPT where deptno = i;
end loop;
END;