Re: Commit transaction
From: Jim Kennedy <kennedy-down_with_spammers_at_no_spam.comcast.net>
Date: Tue, 02 Sep 2003 10:21:06 GMT
Message-ID: <ma_4b.153197$2x.43766_at_rwcrnsc52.ops.asp.att.net>
commit;
Date: Tue, 02 Sep 2003 10:21:06 GMT
Message-ID: <ma_4b.153197$2x.43766_at_rwcrnsc52.ops.asp.att.net>
"DP" <diya30_at_postmark.net> wrote in message
news:5781eab2.0309020207.78ac1542_at_posting.google.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
Received on Tue Sep 02 2003 - 12:21:06 CEST