title: Inserting data in another table having different data structure in oracle
body: <p>I have a table table1</p>
  
  <pre><code>ITEM_CODE             DESC       MONTH      DAY01  DAY02  DAY03
  FG0050BCYL0000CD     CYL HEAD    FEB-15       0       204   408
  FG00186CYL0000CD     POWER UNIT  FEB-15       425    123    202
  </code></pre>
  
  <p>I want to insert data in another table table2 from table1 in such a way.</p>
  
  <pre><code>ITEM_CODE                           MONTH        DATE       QUANTITY
  FG0050BCYL0000CD                    FEB-15    01-FEB-2015      0
  FG0050BCYL0000CD                    FEB-15    02-FEB-2015      204
  FG0050BCYL0000CD                    FEB-15    03-FEB-2015      408
  FG00186CYL0000CD                    FEB-15    01-FEB-2015      425
  FG00186CYL0000CD                    FEB-15    02-FEB-2015      123
  FG00186CYL0000CD                    FEB-15    03-FEB-2015      202
  </code></pre>
  
  <p>Please tell me how to achieve this via pl sql </p>