dynamic parameterized order by clause

I was looking for a way to dynamically build an ORDER BY clause but did not find any advises to handle ascending/descending order.

Here's the solution I came up with:

SELECT * FROM emp

ORDER BY     DECODE(:dynaOrder, 1, empno, NULL) ASC,

    DECODE(:dynaOrder, -1, empno, NULL) DESC,

    DECODE(:dynaOrder, 5, hiredate, NULL) ASC,

    DECODE(:dynaOrder, -5, hiredate, NULL) DESC

Moreover, this way is more flexible mixes column of different types, like date, number, varchar:

Does any body know a better way to implement dynamic parameterized order by clause?

Thanks,

Yuri Received on Wed Jul 30 2003 - 00:56:10 CDT