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, 2157🔥, 0💬
Popular Posts:
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...