Hi,
I'm new in pl/sql. When doing DML inside a block, do I need commit? What is the best practice?
HR@SNDBX11> create table t (
2 a NUMBER(2,0),
3 b VARCHAR2(10));
Table created.
HR@SNDBX11> select a from t;
no rows selected
HR@SNDBX11> insert into t (a) values (1);
1 row created.
HR@SNDBX11> commit;
Commit complete.
HR@SNDBX11> select a from t;
A
----------
1
HR@SNDBX11> begin
insert into t (a) values (2);
end; 2 3
4 /
PL/SQL procedure successfully completed.
HR@SNDBX11> select a from t;
A
----------
1
2