Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DDL
"Rahul Jain" <rahuljain1212_at_gmail.com> wrote in message
news:ef8b6b7f.0411162303.1addc367_at_posting.google.com...
> Why is DDL required to be the last statement in a transaction?
Hi Rahul
It isn't.
Usually a transaction is completed via a COMMIT (or a ROLLBACK).
DDL statements have implicit commits (before and after) and so would end a current transaction although this would be somewhat unusual case.
Check out the Transaction Management section in the Concepts manual.
Cheers
Richard Received on Wed Nov 17 2004 - 03:44:47 CST