Define and Use Table Alias Names in Oracle


How To 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;
-------------------- -------------------- ---------------
Steven               King                 Executive
Neena                Kochhar              Executive
Lex                  De Haan              Executive
Alexander            Hunold               IT
Bruce                Ernst                IT
David                Austin               IT
Valli                Pataballa            IT


Query with a Left Outer Join in Oracle

Query with an Inner Join in Oracle

Understanding SQL SELECT Query Statements in Oracle

⇑⇑ Oracle Database Tutorials

2019-10-27, 1543🔥, 0💬