title: Oracle: Using Pseudo column value in the same Select statement
body: <p>I have a scenario in oracle where i need to be able to reuse the value of a pseudo column which was calculated previously within the same select statement something like:</p>
  
  <pre><code>select 'output1' process, process || '-Output2' from Table1
  </code></pre>
  
  <p>I don't want to the repeat the first columns logic again in the second column for maintenance purposes, currently it is done as</p>
  
  <pre><code>select 'output1' process, 'output1' || '-Output2' name from Table1
  </code></pre>
  
  <p>since i have 4 such columns which depend on the previous column output, repeating would be a maintenance nightmare</p>
  
  <p>Edit: i included table name and removed dual, so that no assumptions are made about that this is not a complex process, my actual statement does have 2 to 3 joins on different tables</p>