title: select to sum the values of one column to other
body: <p>I have a table TABLE_A with one column.</p>
  
  <pre><code>select VALUE from TABLE_A;
  
  VALUE   
  ---------
  1         
  2
  3
  4
  5
  </code></pre>
  
  <p>I need a second column which will give me sum of all the values of first colum.</p>
  
  <p>Expected:</p>
  
  <pre><code>VALUE     SUM
  --------- ---------
  1         15
  2         15  
  3         15
  4         15
  5         15
  </code></pre>
  
  <p>I need to do this without a sub-select query.(select in place of a column)</p>