title: Oracle dynamic DESC and ASC in order by
body: <p>Order by is dynamic but the sort order is static.</p>
  
  <pre><code>SELECT ...
  Order By CASE WHEN InputParam = 'PRICE' THEN OFFER_PRICE END DESC,
           CASE WHEN InputParam = 'ENDING SOON' THEN EXPIRY_DATE END DESC, 
           CASE WHEN InputParam = 'DISCOUNT' THEN DISC_PERCENTAGE END DESC,
           CASE WHEN InputParam = 'SAVING' THEN SAVING END DESC
  </code></pre>
  
  <p>Now I need to make sure that the sort order is also dynamic. Is there some way to make sort order dynamic in the above query?</p>