471,083 Members | 1,176 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,083 software developers and data experts.

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 ?
Jul 19 '05 #1
3 11434
"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
Jul 19 '05 #2
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

Jul 19 '05 #3
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 ?

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Markus Breuer | last post: by
3 posts views Thread by Alberto | last post: by
3 posts views Thread by Mark | last post: by
3 posts views Thread by Peter Kirk | last post: by
7 posts views Thread by fyi85 | last post: by
3 posts views Thread by DP | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.