Oracle column Alias - from keyword not found where expected

Question

SELECT col1 'COLUMN 1'
FROM TABLENAME

I am getting an error 'from keyword not found where expected'

How can you give column alias in Oracle 10g some examples are appreciated

Answer 1

Use double quotes:

SELECT col1 "COLUMN 1" FROM TABLENAME

Answer 2

Shepherdess is correct - you can't use single quotes here.

If the alias doesn't have spaces, you could just type the name without any quotes:

SELECT col1 column1 FROM TABLENAME