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 ......
2019-10-27, 784👍, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in...
What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...