Is it possible to execute multiple DDL statements under a single transaction with Oracle database (10g etc.?) What I'm trying to accomplish is some sort of "upgrade" functionality of the database schema. I have a working implementation of this in SQL Server and I'm planning to port it to Oracle.
start transaction CREATE TABLE A ..... CREATE TABLE B ...... INSERT INTO A.... INSERT INTO B... commit transaction or error rollback transaction