title: Is it possible to insert multiple rows in a table based on a select returning more than one row
body: <p>Using Oracle SQL, I am trying to insert into table A based on select from table B, but I am not sure how to achieve this, since the select is returning more than one row.</p>
  <pre class="lang-sql prettyprint-override"><code>INSERT INTO A
  VALUES
  (
  SELECT id FROM B WHERE status = 'APPROVED',
  'Hardcoded-Value'
  );
  </code></pre>
  <p><strong>Table B</strong>:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>status</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>APPROVED</td>
  </tr>
  <tr>
  <td>2</td>
  <td>DECLINED</td>
  </tr>
  <tr>
  <td>3</td>
  <td>APPROVED</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Based on that insert, I want to achieve following:
  <strong>Table A</strong>:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Column A</th>
  <th>Column B</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>Hardcoded-Value</td>
  </tr>
  <tr>
  <td>3</td>
  <td>Hardcoded-Value</td>
  </tr>
  </tbody>
  </table>
  </div>