Oracle Alias Column

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

Oracle Alias Column example

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

Select 
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.id, s.name, s.salary,
decode (s.salary, 1500, 'Junior',
2500, 'Senior',
5000,'Team Leader',
8000,'Manager'
) As alias_example          
From emp_salaries s
Where s.department='IT'   
Order By s.salary