Dynamic Order By Clause

Hi,

   Can i have a dynamic order by clause, following is my example which    is in a package    

     select * from tab1
     order by columnname_in 

     columnname_in will have the actual column name
     giving the flexibility of ordering by any column which is in tab1
     with out hardcoding the column name

 Thanks in advance
 -Regards
  Prakash C N Received on Wed Nov 21 2001 - 10:12:08 CST