Oracle - How to select and re-alias column by column-position, not column-name? Exp:

SELECT $1 AS NEW_COL_1, $2 AS NEW_COL_2
FROM 
       (SELECT 'x' AS COL_1, 'y' AS COL_2 FROM DUAL)

$1, $2 mean col_1, col_2

I have tried google but no solution yet!

CodePudding user response：

You cannot. SQL does not support that syntax.