Oracle Alias Column

The Oracle Alias Column is used to temporarily rename a column.

Oracle Alias Column example

first_name ||' '|| last_name AS full_name, 
code AS id 
From customers;

o1.offer_id, o1.amount, 
Select count(*) From offers o2
Where o1.amount = o2.amount
) -1
As alias_example
From offers o1
Where o1.offer_id=1;

Select,, s.salary,
decode (s.salary, 1500, 'Junior',
2500, 'Senior',
5000,'Team Leader',
) As alias_example          
From emp_salaries s
Where s.department='IT'   
Order By s.salary