> >
> > OK. May be I miss something.
>
> I don't think so. Not with respect to Oracle. Andreas knows that
> Oracle implicitly commits your running transaction -- and starts
> a new one whenever a DDL statement is encountered. A large
> discussion about this arose about 4 months ago...I can't speak
> for DB2.
Yes, sorry, I think we should leave out the ddl statements here.
The real essential part is the dml statement block in this example.
Since the create table was the first statement in the block,
the only difference between the other db's is wheather the table
exists after a rollback. They will all have the table with one row in
it after a commit.
Andreas