Re: DDL

David Fitzjarrell wrote:

>
>
> Now that you are clear regarding what it is you want, I shall provide:
>
> Original question: "Why is DDL required to be the last statement in a
> transaction?"
>
> Interpretation: "Why must I conclude a transaction with DDL?"

In effect, therefore, "Why must I conclude an 'update EMP set sal=900' with a 'create table FINISHTRANS(Col1 char(5))' statement?"

(substitute any other bit of DML or DDL you care to think of in the appropriate place).

> Nothing in the original question, posted verbatim above, mentions any
> DDL the OP has written; the inherent meaning and frame of reference
> is, therefore, open to interpretation. Had the OP written: "Why must
> I put my DDL statements at the end of a transaction?" there would be
> no ambiguity, and but one interpretation.

I am afraid I must continue to disagree, since this particular re-statement of the question is no less ambiguous than the original. Or no more ambiguous. But whatever.

> I hope this satisfies your thirst for my interpretation of the
> original question.

It does. It means we have some regualrs here who genuinely think that newbies might actually have come to believe that an 'alter table' (or similar piece of DDL) is needed to terminate a (DML) transaction. Which I find extraordinary: I am certainly pessimistic about the general state of Oracle education, but I had no idea others were quite so appalled by it.

HJR Received on Sun Nov 21 2004 - 21:55:59 CST