sql server - Change column name in Oracle in SELECT statement

Question

In MSSQL I can select a column and change the column header by doing:

SELECT mycolumn as 'MyNewColumnName' from MyTable

This doesn't work in Oracle. How do I perform the same thing in Oracle?

question from:https://stackoverflow.com/questions/17944104/change-column-name-in-oracle-in-select-statement

Answer 1

1. Remove single quotation marks

   SELECT mycolumn as MyNewColumnName 
     from MyTable
   

2. Enclose alias in double quotation marks

   SELECT mycolumn as "MyNewColumnName" 
     from MyTable