« IsNumeric() function in C#? | Base Class Library Samples »

Sort based on input parameter in oracle query.

by Vahid 10. January 2009 09:15

Today I was tracing a defect happened in a stored procedure with paging functionality. After spending sometimes on it I came to know that sorting does not work properly. In the order by clause of the procedure we were using an input parameter which holds the column name based on which the result was to be sorted. But it seems that oracle and pl-sql does not support this feature and if we want to sort based on an input parameter we have to go for dynamic query which I don’t like at all.But it’s funny that the feature is not there in oracle because the same thing can be done in ms sql server easily.Anyone got some idea about this, please let me know.

Technical

Comments (0)

Oracle Connection String Without tnsnames.ora file for .net ever wanted to connect to an oracle database in your .net application (asp.net, windows client ect…Could not create the driver from NHibernate.Driver.OracleDataClientDriver error in NHibernateI have been playing with Nhibernate to connect to an oracle database using ODP.NET. first POC projec…Could not load file or assembly ‘Oracle.DataAccess’ or one of its dependencies. An attempt was made to load a program with an incorrect formatI had deploying an asp.net application to a windows 2008 64bit server. the application uses od…

Sort based on input parameter in oracle query.#

Sort based on input parameter in oracle query.