SQL & PL/SQL

Hello,

I am trying to create a formula in an sql statement without creating a external function.

Here is my example :

select (x + y) as a,
(x + y) + 2
from dual


As you can see the formula “(X + Y)” is repeated.

I would be glad to write a select statement like that :


select (x + y) as a,
a + 2
from dual


any ideas?

Thanks