title: Unable to 'SELECT INTO' when value doesn't exist
body: <pre><code>SELECT Value1 INTO lValue
  FROM   Table1
  WHERE  Field1 = lTempValue;
  </code></pre>
  
  <p>This works fine when the match is true.  But if the match isn't true, I receive an error.</p>
  
  <pre><code>ORA-01403: no data found
  </code></pre>
  
  <p>Ideally, that's fine with me because I'm going to check that value next to see if it's above 0 and if it is, use that value in an insert query.  I don't want to check for the value and then have to run the same query to retrieve it essentially, I want to do it in one query if possible, but I can't figure out how that is done.</p>
  
  <p>If there's a value, then I want that value to go into lValue.  If there is no value, then I want 0 to go into lValue.  Anyone got any ideas?  I've only done a quick google check, but it came up dry.  Figured I'd post this while looking.  Thanks for the help.</p>