title: Use Column Alias In Select Statement Calculation Oracle SQL
body: <p>Is it possible to do something like <code>select 1 as foo, foo+1 from dual</code></p>
  
  <p>This returns <code>ERROR at line 1: ORA-00904: "FOO": invalid identifier</code></p>
  
  <p>I have a lengthy calculation  that composes a column and I would like to be able to easily use that value for calculation in a difference column</p>