|
This course examines joining tables in Oracle9i SQL using the ANSI format JOIN clause and the Oracle proprietary format.
Objectives:
After completing this course, students will be able to:
- Write SELECT statements to access data from more than one table using equality and nonequality joins
- View data that generally does not meet a join condition by using outer joins
- Join a table to itself using a self join
- Create various types of join queries
- Identify the differences between Oracle proprietary format and ANSI format for joining tables
Topics:
- Joining tables
- Cross joins
- Natural joins
- The USING and the ON clause
- Outer joins
- Left outer joins
- Right outer joins
- Self joins
- Other types of joins
|
