Selecting all columns and constant value from Oracle table

Select *,5 as "ConstColumn" From TableA;

sql oracle select dml

Try,

Select TableA.*, 5 as "ColumnAlias" From TableA

sql oracle select dml

I don't think this is really possible, because the * character is not a replacing content.I get back this error: ORA-00923

CodeHunter