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: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 20 Nov 2004 08:44:21 -0800
Message-ID: <1100968979.103412@yasure>


Howard J. Rogers wrote:

> Assuming one actually writes a piece of DDL somewhere, anywhere, then
> yes it is indeed the last statement in a transaction.

I hate to continue to drag this out Howard but why not just acknowledge that Richard is correct? He is! Your assumption was not part of the OP's post. Of course you are technically correct ... but you have invented the condition in which you are correct.

>> That's the fuzzy wuzzy picture you haven't been seeing. That's all it
>> is !!
>
> Nothing fuzzy or wuzzy about it. The original question rather predicates
> that *some* DDL is being issued, does it not? [See below. I see now
> that oddly enough for you, it doesn't].

I think you are stretching.

>> I guess the question must be a tad ambiguous considering the epic this
>> thread's become !!
>
> Not necessarily. It could be that some have leapt to conclusions...

And that some invented conditions not written by the OP.

>> There is no need for *any* DDL to be in a transaction at all. *None*.
>
> I would have thought that anyone who can write about DDL and
> transactions knows at least enough about Oracle to know that that is one
> of those statements which falls into the bleedin' obvious category.

Stretching.

>> Trouble is we're both right. It's just that you've always assumed
>> there to be some DDL involved somewhere along the line. I haven't.
>
> Whatever. I think it bizarre to assume he was asking whether DDL was
> compulsory when attempting to update EMP's salaries. As opposed to
> wondering where to place a DDL statement in a mixed bit of SQL.
>
> But yes, that was indeed an assumption I had made.

Yeah! Can we now just let this thread fade away.

> Why? You don't think it important to know what the original poster
> meant? Or how it is possible to misunderstand, each other and the OP?
>
> HJR
I agree with the last statement ... but I've not seen the OP post again with a clarification so we are all squinting and stretching attempting to divine hard facts from an ambiguity. Lets not take this any further unless the OP decides to clarify the original request.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sat Nov 20 2004 - 10:44:21 CST

Original text of this message

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