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, 1582🔥, 0💬
Popular Posts:
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...