Selecting all columns and constant value from Oracle table

Question

How can I select all columns and add a column with a constant value in Oracle?

With MS SQL Server, I can use:

Select *,5 From TableA;

I will get this:

column1      column2    5
xx           xx         5
xx           xx         5

Answer 1

See this tutorial: Select constant as a Column

Select *,5 as "ConstColumn" From TableA;