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
andASC/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/sortingorder combination)
If it's not possible, could anyone implement this feature into one of future versions? I think that it would be quite
handyto have something like that.
Thank you for your responses.
-------------------
Menu.sk - Denne aktualizovany zoznam obedovych menu a restauracii s presnou lokalizaciou.