Column Aliasing 2

[Ascalonian]

I was just curious if there is a difference between:

SELECT column_a AS some_column 
FROM DUAL;

or

SELECT column_a some_column 
FROM DUAL;

Is there any advantage to using the AS keyword?

 

[LKBrwnDBA]

Some Oracle versions do not recognize the "AS".



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

PS: Otherwise it's equivalent...

.

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Turkbear]

Hi,
In addition ( and just barely related), by enclosing the alias in "s you can have nice mixed case column headings and spaces.

Select empname as "Employee Name" from mytable;, for instance



To Paraphrase:"The Help you get is proportional to the Help you give.."