Orcale SQL Tutorial
Loading...
Aliases
ORACLE ALIASES
In Oracle, aliasing can also be done in column name as well as in table name. Aliasing is done to give a temporary to a column or table.
Syntax for column:
- Column_name AS alias_name
Syntax for table:
- Table_name alias_name
Parameters
column_name: original name of the column
table_name: original name of the table
alias_name: temporary name
Table:
Example 1
| select id, name as Student_name from table1 |
Example 2
| select s.id, s.name from table1 s |
