title: Stored Procedure for copying data from one table to another
body: <p>I have <strong>pairs of tables</strong> in the format <code>TABLE</code> and <code>TABLE_TWIN</code> now</p>
  
  <ul>
  <li><code>TABLE</code> is the main table with lots of data</li>
  <li><code>TABLE_TWIN</code> is a table with the exact same fields with a little data (different data)</li>
  </ul>
  
  <p>Now I would like to copy all rows from <code>TABLE_TWIN</code> to <code>TABLE</code> using a stored procedure. I have many such tables and could like the stored procedure to take the table name(s) as parameter(s) so that I can use the same procedure for each table pair. I do not want to write <strong>long <code>INSERT</code></strong> statements because these tables have around 50 attributes each.</p>
  
  <p>I am not good with PL/SQL so I need some help here.</p>
  
  <p>Thanks!</p>