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: Order by must be construct by variable

Re: Order by must be construct by variable

From: DA Morgan <damorgan_at_exxesolutions.com>
Date: Sat, 15 Mar 2003 10:12:45 -0800
Message-ID: <3E736D1D.E2648401@exxesolutions.com>


Oraclion wrote:

> Hi
>
> I don't want use DBMS_SQL (Code translation of my query to DBMS is too hard,
> 700 lines ... hum)
>
> For example i want to create my query
> SELECT * FROM T WHERE ... ORDER by Buff
>
> Is there a way to compute order by in buff
> => CURSOR C1(buff) Is SELECT * FROM T WHERE ... ORDER by Buff;
> begin
> buff := field1 ASC, Field2 DESC;
> OPEN C1(buff);
> ....
> end;
>
> if no solution i'll go in DBMS_SQL but not cool for this query.
>
> Besrs regards
> Oraclion

Can you use DECODE in your ORDER BY?

Daniel Morgan Received on Sat Mar 15 2003 - 12:12:45 CST

Original text of this message

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