Oracle: Using Pseudo column value in the same Select statement

oracle, select

Solution

You could calculate the value in a sub-query:

select calculated_output process, calculated_output || '-Output2' name from
(
    select 'output1' calculated_output from dual
)

Problem

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: ``` select 'output1' process, process || '-Output2' from Table1 ``` I don't want to the repeat the first columns logic again in the second column for maintenance purposes, currently it is done as ``` select 'output1' process, 'output1' || '-Output2' name from Table1 ``` since i have 4 such columns which depend on the previous column output, repeating would be a maintenance nightmare 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

Original source