Re: The ROLLBACK don't cancel instructions

"Michel Cadot" <micadot_at_netcourrier.com> wrote in message news:<9n7g1u$6se$1_at_s1.read.news.oleane.net>...
> "Ben-oui" <aslamette_at_free.fr> a écrit dans le message news:
> xiHl7.3702$125.4572254_at_nnrp5.proxad.net...
> > Thank you,
> > but, there isn't any possibility to cancel this 'auotcommit' ?
> >
>
> No.

Michel is correct, but he should have said that all DDL is preceeded by and followed by an 'implicit' commit. Autocommit is an SQL*Plus feature you can turn off or on to automatically issue commits for DML statements.

When you code a commit (or rollback) you are performing an 'explicit' commit. If you exit SQL*Plus with uncommitted modified data SQL*Plus will commit for you, 'implicit'.

• Mark D Powell --