Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

some way for to order ASC or DESC

muttleychessDec 6 2007 — edited Dec 12 2007
Hi

is there some way for a query to order ASC or DESC when the user to pass 1 or 2 in parameter
EXPLAIN
   Select  column1,column2...column3
      from  mytables
       WHERE .....
      ORDER BY   -- here I must put ASC  if user put 1 in Parameter in Procedure or  DESC
        if user put 2
tia
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 9 2008
Added on Dec 6 2007
15 comments
625 views