mark.powell_at_eds.com (Mark D Powell) wrote in message news:<178d2795.0109060746.7544f6d_at_posting.google.com>...
<snip>
> 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 --
I'm not sure about the "alter table" but how about wrapping the statements
in a "create schema"? That way you do get the chance to issue a rollback for DDL.
SteveM
Received on Fri Sep 07 2001 - 02:51:26 CDT
