Change column name in Oracle in SELECT statement

Remove single quotation marks

SELECT mycolumn as MyNewColumnName   from MyTable

Enclose alias in double quotation marks

SELECT mycolumn as "MyNewColumnName"   from MyTable

sql-server oracle select columnname

In Oracle you can just provide a space after the column name and provide the alias name without any quotes as

 SELECT mycolumn MyNewColumnName from MyTable

CodeHunter