Using Parameters in Order By Clause in PL - SQL

Tutorials Shared by the Internet Community


Using Parameters in Order By Clause in PL - SQL

Today I was working on a data table, output in HTML generated by PL/SQL


  • Total Hits - 37113

  • Total Votes - 113 votes

  • Vote Up - 50 votes

  • Vote Down - 63 votes

  • Domain -

  • Category - Oracle/Oracle Misc

  • Submitted By - Shekhar

  • Submitted on - 2008-04-15 01:56:23


Basically I have a procedure which takes a parameter (p_sort_by) and establishes which column to sort by based on this parameter. It does this using the DECODE function, which has similar functionality to IF-THEN-ELSE statements. I could have alternatively used CASE statements here, which are easier to understand, but they are not supported in older versions of Oracle.    More detail...

Broken  |   Save  |   Liked  |   Down

E-Books Store