Oracle: Aliases

ALIASES in Oracle helps to create provide a temporary name to a column or table in a database just to make it easily understandable. Keyword AS is used to describe an Alias in Oracle. ALIAS in Oracle is performed in two different ways. Follow the below syntax to understand ALIAS in a better way.


For suppose we have Stu Table as Shown below:a
Stu Table
1). By using AS

select name as first_name from Stu;

2). Without using AS

Select name First_name from Stu;


Select name AS First_name from Stu;


You will get the same output using both the syntaxes above:

ALIAS in sql

NOTE: You can also set ALIAS for Table as a whole. Follow the below syntax for the same:

Select name from Stu Student;

ALIAS in sql