By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,089 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

Commit transaction

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
"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

P: n/a
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

P: n/a
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.