title: Create Oracle Tables in a Loop
body: <p>I am trying to create 1 PL/SQL statement that would allow me to get multiple table outputs after each successive datetime iteration and rename each table with the year of that datetime iteration. Example below with desired results. Thanks</p>
  
  <pre><code>  Create table MY_TIME_XX AS 
     ( Select 
      X.* 
      FROM Metadata X )
      Where X.Datetime between '01/01/2014' and '12/31/2014'
  </code></pre>
  
  <p>So in the end my schema will have </p>
  
  <ol>
  <li>MY_TIME_14 </li>
  <li>MY_TIME_15 </li>
  <li>MY_TIME_16</li>
  </ol>
  
  <p>etc....</p>