Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Define and Use Table Alias Names
How To Define and Use Table Alias Names? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: 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 ......
2007-04-19, 5341👍, 0💬
Popular Posts:
What are the two kinds of comments in JSP and what's the difference between them? <%-- JSP Co...
Does there exist any other function which can be used to convert an integer or a float to a string? ...
1. What is normalization. 2. Difference between procedure and functions. 3. Oracle 9i Vs 10g. 4. how...
How To Create Nested Tables? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells You can cr...
Why is it preferred to not use finalize for clean up? Problem with finalize is that garbage collecti...