begin
update salary set bonus = 1000 where emp_id = 10;
if sql%notfound then
insert salary(bonus)values(100);
end if;
.................
2、
create or replace procedure delDept(p_deptno in dept.deptno%type) is
EmpCount NUMBER; --影响的记录数
begin
delete from dept where deptno=p_deptno;
EmpCount := SQL%ROWCOUNT;
if(EmpCount <>0)
then
dbms_output.put_line('部门删除成功...');
exception when others then
dbms_output.put_line('部门删除失败...');
end;