Sql ORDER BY and ASC/DESC question

["Jaroslav Sivy" <yarex(at)pobox(dot)sk>]

Hello everyone,

I have following problem: am using pl/sql functions to trigger some sql code and i need to pass ORDER_BY column name and ASC/DESC sorting order as an input parameters into that function
and order the result based on these input parameters.

The problem is, that the only way is to create query as "string" and then execute it as "string".

Is there any other way around how to avoid that "string query"?

(i don't want to use IFs either, because 5 columns x 2 sorting orders would require 10 IFfed queries with different column/sorting order combination)


If it's not possible, could anyone implement this feature into one of future versions? I think that it would be quite handy to have something like that.

Thank you for your responses.
-------------------
Menu.sk - Denne aktualizovany zoznam obedovych menu a restauracii s presnou lokalizaciou.

Attachment: attachment.txt
Description: attachment.txt