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;
执行更新、插入语句时一定要手动提交,否则结果出错!
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;
执行更新、插入语句时一定要手动提交,否则结果出错!