Oracle - Define and Use Table Alias Names in Oracle

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, 331👍, 0💬