Change column name in Oracle in SELECT statement

oracle, select, sql-server

Solution

Remove single quotation marks

SELECT mycolumn as MyNewColumnName 
  from MyTable

Enclose alias in double quotation marks

SELECT mycolumn as "MyNewColumnName" 
  from MyTable

Problem

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 Database. How do I perform the same thing in Oracle Database?

Original source