title: How to use the value returned by the SUM() function in oracle sql
body: <p>I need to use the value returned by the SUM() function in sql inside my IF statement. I can't seem to assign a declared variable to have its value after using it. </p>
  
  <p>For example, I used SUM() to add 5 columns in a table and returned 5. I wanna use that 5 value in the condition of my IF statement:</p>
  
  <p>IF <em>sum_return_value</em> = 5 THEN </p>
  
  <p><em>statement</em></p>
  
  <p>Is there a way of doing it? I'm using oracle sql developer</p>