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:

snippet
Column_name AS alias_name

Syntax for table:

snippet
Table_name  alias_name

Parameters

column_name: original name of the column

table_name: original name of the table

alias_name: temporary name

Table:

ORACLE ALIASES

Example 1

select id, name as Student_name from table1

ORACLE ALIASES

Example 2

select s.id, s.name from table1 s

ORACLE ALIASES
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents