Oracle - consulta

quisiera saber si es posible generar una columna a partir de otras dos,

algo asi:

SELECT SALARY, ROUND(SALARY + (SALARY * 0.155)) AS "New Salary",
(SALARY - [New Salary] ) as "Increase"
FROM EMPLOYEES;

es decir, generar Increase, a partir de una columna existente llamada salary, y una columna calculada llamada New Salary

Gracias!!

Por supuesto, modifica tu SELECT de la siguiente manera:

WITH Q as (
SELECT SALARY, ROUND(SALARY + (SALARY * 0.155)) AS NEW_SAL FROM EMPLOYEES
)
SELECT SALARY
, NEW_SAL AS "New Salary"
, SALARY - NEW_SAL as "Increase"
FROM Q;