Define and Use Table Alias Names in Oracle

Q

How To Define and Use Table Alias Names in Oracle?

✍: FYIcenter.com

A

When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names as shown in the following select statement:

SQL> SELECT e.first_name, e.last_name, d.department_name
  FROM employees e INNER JOIN departments d 
  ON e.department_id=d.department_id;
FIRST_NAME           LAST_NAME            DEPARTMENT_NAME
-------------------- -------------------- ---------------
Steven               King                 Executive
Neena                Kochhar              Executive
Lex                  De Haan              Executive
Alexander            Hunold               IT
Bruce                Ernst                IT
David                Austin               IT
Valli                Pataballa            IT
......

 

Understanding SQL SELECT Query Statements in Oracle

⇒⇒Oracle Database Tutorials

2016-10-16, 135👍, 0💬