title: Oracle DBMS package command to export table content as INSERT statement
body: <p>Is there any subprogram similar to <code>DBMS_METADATA.GET_DDL</code> that can actually export the table data as <code>INSERT</code> statements?</p>
  
  <p>For example, using <code>DBMS_METADATA.GET_DDL('TABLE', 'MYTABLE', 'MYOWNER')</code> will export the <code>CREATE TABLE</code> script for MYOWNER.MYTABLE. Any such things to generate all data from MYOWNER.MYTABLE as <code>INSERT</code> statements?</p>
  
  <p>I know that for instance TOAD Oracle or SQL Developer can export as <code>INSERT</code> statements pretty fast but I need a more programmatically way for doing it. Also I cannot create any procedures or functions in the database I'm working.</p>
  
  <p>Thanks.</p>