AS

You can use an AS clause in a SELECT statement to name or rename a result column in a query. The name must not be qualified and does not have to be unique.

For example:

SELECT NAME, SALARY*0.05 AS "RAISE"
  FROM Q.STAFF

If the AS clause is not specified and the result column is derived from a column name, the result column name is the unqualified name of that column.