How you will create a column alias? (Oracle 8i)

The AS keyword is optional when specifying a column alias. You must
enclose the column alias in double quotes when the alias
contains a space or lowercase letters. If you specify an alias in
lowercase letters without double quotes, the alias will appear in
uppercase.