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]

Re: Commit transaction

"DP" <diya30@postmar k.netwrote in message
news:5781eab2.0 309020207.78ac1 542@posting.goo gle.com...

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]

Re: Commit transaction

Take a look at savepoints.

ETA


"Jim Kennedy" <kennedy-down_with_spamm ers@no_spam.com c
ast.netwrote in message news:<ma_4b.153 197$2x.43766@rw crnsc52.ops.asp .att.net>...

"DP" <diya30@postmar k.netwrote in message
news:5781eab2.0 309020207.78ac1 542@posting.goo gle.com...

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]

Re: Commit transaction

at your case - none,
"DP" <diya30@postmar k.netwrote in message
news:5781eab2.0 309020207.78ac1 542@posting.goo gle.com...

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 ?