title: Reasonable SELECT ... INTO Oracle solution for case of multiple OR no rows
body: <p>I just want to SELECT values into variables from inside a procedure.</p>
  
  <p>SELECT blah1,blah2 INTO var1_,var2_
  FROM ...</p>
  
  <p>Sometimes a large complex query will have no rows sometimes it will have more than one -- both cases lead to exceptions.  I would love to replace the exception behavior with implicit behavior similiar to:</p>
  
  <p>No rows = no value change, Multiple rows = use last</p>
  
  <p>I can constrain the result set easily enough for the "multiple rows" case but "no rows" is much more difficult for situations where you can't use an aggregate function in the SELECT.</p>
  
  <p>Is there any special workarounds or suggestions?  Looking to avoid significantly rewriting queries or executing twice to get a rowcount before executing SELECT INTO.</p>