Change column name in Oracle in SELECT statement

sql-server oracle select columnname
CathalMF picture CathalMF · Jul 30, 2013 · Viewed 90.4k times · Source

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?

Answer

Nick Krasnov picture Nick Krasnov · Jul 30, 2013

  1. Remove single quotation marks

    SELECT mycolumn as MyNewColumnName 
  from MyTable

  2. Enclose alias in double quotation marks

    SELECT mycolumn as "MyNewColumnName" 
  from MyTable

Related questions

The order of a SQL Select statement without Order By clause

As I know, from the relational database theory, a select statement without an order by clause should be considered to have no particular order. But actually in SQL Server and Oracle (I've tested on those 2 platforms), if I query from …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
Is there a combination of "LIKE" and "IN" in SQL?

In SQL I (sadly) often have to use "LIKE" conditions due to databases that violate nearly every rule of normalization. I can't change that right now. But that's irrelevant to the question. Further, I often use conditions like WHERE something …

Read More