Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Order by must be construct by variable
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