Commit transaction

[DP]

Is there any command exists as "commit transaction" ?

begin transaction
< DML1 stmts >
begin transaction
< DML2 stmts >
rollback transaction
commit transaction

which set of DML will be commites to the database or none ?

[Jim Kennedy]

"DP" <di****@postmark.net> wrote in message
news:57**************************@posting.google.c om...

Is there any command exists as "commit transaction" ?

begin transaction
< DML1 stmts >
begin transaction
< DML2 stmts >
rollback transaction
commit transaction

which set of DML will be commites to the database or none ?

Transactions start or end with commit or rollback. eg
commit;
dml;
dml;
dml;
commit;

or
commit;
dml;
dml;
....
rollback;

AFAIK in Oracle anything after the commit is ignored as a label. eg commit
mytrans;
Jim

[Ethel Aardvark]

Take a look at savepoints.

ETA
"Jim Kennedy" <kennedy-down_with_spammers@no_spam.comc
ast.net> wrote in message news:<ma*******************@rwcrnsc52.ops.asp.att. net>...

"DP" <di****@postmark.net> wrote in message
news:57**************************@posting.google.c om...

Is there any command exists as "commit transaction" ?

begin transaction
< DML1 stmts >
begin transaction
< DML2 stmts >
rollback transaction
commit transaction

which set of DML will be commites to the database or none ?

Transactions start or end with commit or rollback. eg
commit;
dml;
dml;
dml;
commit;

or
commit;
dml;
dml;
...
rollback;

AFAIK in Oracle anything after the commit is ignored as a label. eg commit
mytrans;
Jim

[Julia Sats]

at your case - none,
"DP" <di****@postmark.net> wrote in message
news:57**************************@posting.google.c om...

Is there any command exists as "commit transaction" ?

begin transaction
< DML1 stmts >
begin transaction
< DML2 stmts >
rollback transaction
commit transaction

which set of DML will be commites to the database or none ?