title: PLSQL Insert into with subquery and returning clause
body: <p>I can't figure out the correct syntax for the following pseudo-sql:</p>
  
  <pre><code>INSERT INTO some_table
             (column1,
              column2)
       SELECT col1_value, 
              col2_value 
         FROM other_table
        WHERE ...       
    RETURNING id
         INTO local_var; 
  </code></pre>
  
  <p>I would like to insert something with the values of a subquery.
  After inserting I need the new generated id.</p>
  
  <p>Heres what oracle doc says:</p>
  
  <p><a href="http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/insert_statement.htm#sthref2803">Insert Statement</a></p>
  
  <p><a href="http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/returninginto_clause.htm">Returning Into</a></p>
  
  <p>OK i think it is not possible only with the values clause...
  Is there an alternative?</p>