09PL_SQL过程之执行insert语句

declare
  v_deptno dept.deptno%type := 50;
  v_dname dept.dname%type := 'aaaa';
  v_loc dept.loc%type := 'bj';
begin
  insert into dept values(v_deptno,v_dname,v_loc);
  commit;
end;


执行更新、插入语句时一定要手动提交，否则结果出错！