Is the 'as' keyword required in Oracle to define an alias?
alias, oracle, required, sql
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
Problem
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.