---

Oracle Aliases

In Oracle Aliases are usually used to give a temporary name to table, or a column. Using aliases you can make column names more readable.

Oracle ALIASES COLUMN Syntax

To give a temporary name to table, or a column., use the following syntax:

Oracle ALIASES COLUMN example

The following Oracle, creates two aliases, one for the "custID" column and one for the "custName" column:

Note:

In the above example, we are creating two aliases, one for the "custID" column and one for the "custName" column.

Oracle ALIASES TABLE Syntax

To give a temporary name to table, or a column., use the following syntax:

Oracle ALIASES TABLE example

The following Oracle, creates two aliases, one for the "tblCustomerLoan" table and one for the "tblCustomer" table:

---

---