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.

 

Tags: ,

Technical

Comments

4/18/2011 2:55:19 PM #

darmowe filmy porno

An attractive discussion is value comment. I believe that you need to write extra on this matter, it might not be a taboo argument but as usual persons are not enough to speak on such topics. To the next.

darmowe filmy porno United States

4/19/2011 1:05:49 AM #

Corinna Toll

I find myself coming to your blog more and more often to the point where my visits are almost daily now!

Corinna Toll United States

4/19/2011 9:14:06 PM #

pozycjonowanie

Spot on with this write-up, I truly think this website needs much more consideration. I’ll probably be again to read much more, thanks for that info.

pozycjonowanie United States

4/20/2011 8:40:11 PM #

color contacts

Hmm it seems like your blog ate my first comment (it was extremely long) so I guess I'll just sum it up what I wrote and say, I'm thoroughly enjoying your blog. I too am an aspiring blog writer but I'm still new to everything. Do you have any points for rookie blog writers? I'd definitely appreciate it.

color contacts United States

4/22/2011 11:11:34 PM #

Southie Cab

http://www.betaparticle.com/search.aspx?q=5 Year Anniversary of the Minot Train Derailment%2C the largest chemical spill in U.S. history &page=3

Southie Cab United States

4/22/2011 11:51:13 PM #

contemporary bedroom furniture

I was really encouraged to find this website. I wanted to thank you for this unique study. I certainly savored each and every tiny little bit of it such as every one of the comments and i have you bookmarked to check out new stuff you article.

contemporary bedroom furniture United States

4/24/2011 12:28:53 PM #

Isaias Kaye

Glad to be  one of several visitors   on this  awesome   web site  : D.

Isaias Kaye United States

4/24/2011 11:01:12 PM #

Gregory Despain

This is getting a bit more subjective, but I much prefer the Zune Marketplace. The interface is colorful, has more flair, and some cool features like 'Mixview' that let you quickly see related albums, songs, or other users related to what you're listening to. Clicking on one of those will center on that item, and another set of "neighbors" will come into view, allowing you to navigate around exploring by similar artists, songs, or users. Speaking of users, the Zune "Social" is also great fun, letting you find others with shared tastes and becoming friends with them. You then can listen to a playlist created based on an amalgamation of what all your friends are listening to, which is also enjoyable. Those concerned with privacy will be relieved to know you can prevent the public from seeing your personal listening habits if you so choose.

Gregory Despain United States

4/24/2011 11:27:20 PM #

Wendy

I can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me.. Thanks for all your help and wishing you all the success in your business.

Wendy United States