title: sql oracle new temp column
body: <p>My SQL output is like this:</p>
  
  <pre><code>column1
  
  50
  20
  30
  </code></pre>
  
  <p>My final result should be:</p>
  
  <pre><code>    column1   column1_temp
  
  #1  50        50%
  #2  20        20%
  #3  30        30%
  </code></pre>
  
  <p><strong>What should happen in text:</strong></p>
  
  <pre><code>SQL SUM(column1 #1-#3) = 100 (or what ever comes out as result) which is 
  100% |  column1 #1 50 from 100 is 50%
          column1 #2 20 from 100 is 20%
          column1 #3 30 from 100 is 30%
  </code></pre>