Collections:
Define and Use Table Alias Names in Oracle
How To Define and Use Table Alias Names in Oracle?
✍: FYIcenter.com
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 ......
⇒ Query with a Left Outer Join in Oracle
⇐ Query with an Inner Join in Oracle
2019-10-27, 1571🔥, 0💬
Popular Posts:
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...