Search code examples
sqloracle-databasealiasrequired

Is the 'as' keyword required in Oracle to define an alias?

Is the 'AS' keyword required in Oracle to define an alias name for a column in a SELECT statement?

I noticed that 

SELECT column_name AS "alias"

is the same as

SELECT column_name "alias"

I am wondering what the consequences are of defining a column alias in the latter way.

Solution

  • According to the select_list Oracle select documentation the AS is optional.

    As a personal note I think it is easier to read with the AS