Re: Commit transaction

Take a look at savepoints.

ETA "Jim Kennedy" <kennedy-down_with_spammers_at_no_spam.comc ast.net> wrote in message news:<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 - 15:29:22 CEST