title: Use Variabel for 'ORDER BY ' Declartion in a FOR IN LOOP Oralce
body: <p>In ORACLE please.</p>
  <p>Is it possible to have a variable in the 'ORDER BY' Statment?</p>
  <p>So iam currenty creating a procedure in which I need to have a dynamic Order by.
  Is there any way to do this ?</p>
  <pre><code>CREATE OR REPLACE PROCEDURE TEST1
  
  vorder varchar(250);
  ...
  
  vOrder := 'number';
  FOR o IN (SELECT * FROM TABLENAME order by vOrder)
  LOOP
  -- Some stuff ---
  
  END LOPP;
  ....
  </code></pre>