title: How to output result of SELECT statement which is executed using native dynamic SQL?
body: <p>I have a string which contains SQL <code>SELECT</code> statement.<br>
  I wonder how can I output result of the execution of that statement on the screen, execution will be done <strong>using native dynamic SQL</strong> (<code>EXECUTE IMMEDIATE</code>).</p>
  
  <p>example:</p>
  
  <pre><code>DECLARE
  v_stmt VARCHAR2 := 'SELECT * FROM employees';
  BEGIN
  EXECUTE IMMEDIATE v_stmt; -- ??? how to output result of that select on the screen.
  END;
  </code></pre>
  
  <p>Important remark: structure of table can be any. I have to write a procedure which accepts name of the table as parameter, so I can't hardcode a table structure and don't want to do it.</p>
  
  <p>Thanks for responses. Any ideas very appreciated/</p>