title: How do I fix ORA-01427: single-row subquery returns more than one row
body: <p>This query:</p>
  
  <pre><code>SELECT u2.MR_ID from up_module_master u2 where u2.MR_NAME='Applications'
  </code></pre>
  
  <p>returns two rows but when i created it I created only one row.</p>
  
  <pre><code>INSERT INTO UP_PERMISSION_MASTER ( MR_ID,P_NAME,P_HOLDER)
     values ((SELECT u2.MR_ID from up_module_master u2
              where u2.MR_NAME='Applications'),'create','0')
  </code></pre>
  
  <p>How do I fix ORA-01427: single-row subquery returns more than one row</p>