Re: Question about Queries

From: joel garry <>
Date: Thu, 25 Dec 2008 08:38:27 -0800 (PST)
Message-ID: <>

On Dec 25, 5:30 am, William Robertson <> wrote:
> On Dec 24, 9:30 pm, Mladen Gogala <> wrote:
> > >Second, is using EXECUTE IMMEDIATE for doing a SELECT faster than a
> > >normal coded SELECT?
> I must admit I could never see the sense of the "IMMEDIATE" keyword
> here. Perhaps the standard allows for some "DEFERRED" option for
> background submission, that no vendor currently supports? Otherwise
> you'd think EXECUTE STATEMENT would have made rather more sense. Then
> again anything is possible from the geniuses who came up with LEFT and
> RIGHT alternatives for join syntax.

That struck me odd, got curious, found this:

And stretching the brain some, Oracle native dynamic sql basically has prepare and execute, they just don't call it that:


-- is bogus.
Received on Thu Dec 25 2008 - 10:38:27 CST

Original text of this message