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: Dynamic Order By Clause

Re: Dynamic Order By Clause

From: Mladen Gogala <mgogala_at_earthlink.net>
Date: Fri, 23 Nov 2001 03:50:57 GMT
Message-ID: <pan.2001.11.22.22.50.49.148.2387@earthlink.net>


In article <9the140lkn_at_drn.newsguy.com>, "Thomas Kyte" <tkyte_at_us.oracle.com> wrote:

>>Actually, this is a trick that could have been more easily accomplished
>>by using  EXECUTE IMMEDIATE.

>
> don't keep me in suspense, how would you do this with execute immediate?
> that can execute single statement or a select query that returns A row.

Yes, you are right. Execute immediate does return only one row. My mistake.

-- 
Mladen Gogala
Received on Thu Nov 22 2001 - 21:50:57 CST

Original text of this message

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