Re: Question about Queries

From: gym dot scuba dot kennedy at gmail <kennedyii_at_verizon.net>
Date: Wed, 24 Dec 2008 22:13:40 GMT
Message-ID: <ouy4l.973$Es4.483@nwrddc01.gnilink.net>

"Mladen Gogala" <mgogala_at_yahoo.com> wrote in message news:giu9mc$rt0$3_at_ss408.t-com.hr...
> On Wed, 24 Dec 2008 09:44:43 -0800, mrdjmagnet wrote:
>
>> Second, is using EXECUTE IMMEDIATE for doing a SELECT faster than a
>> normal coded SELECT?
>
> Yes, with EXECUTE IMMEDIATE, statement is executed immediately while
> with normal coded select one must wait for the RTFM timer.
>
>
>
> --
> http://mgogala.freehostia.com

That's related to the dbms_lock.sleep() call right. :) Received on Wed Dec 24 2008 - 16:13:40 CST

Original text of this message