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.

Syntax

For suppose we have Stu Table as Shown below:a

1). By using AS

select name as first_name from Stu;

2). Without using AS

Select name First_name from Stu;

Example

Select name AS First_name from Stu;

Output

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

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

Select name from Stu Student;

Output