plsql编程中变量的声明(二)
ount number;
begin
update emp2 set sal=sal/2 where deptno =v_deptno;
--select deptno into v_deptno from emp2 where empno = 7369;
-- select count(*) into v_count from emp2;
dbms_output.put_line(sql%rowcount || '条记录被影响');
commit;
end;