Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DDL

Re: DDL

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Wed, 17 Nov 2004 09:44:47 GMT
Message-ID: <j4Fmd.39181$K7.37024@news-server.bigpond.net.au>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US