Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Overview/Description
To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with RDBMS technologies and programming techniques
Expected Duration (hours)
2.2
Lesson ObjectivesDisplaying Multiple Table Data and Using Set Operators in Oracle Database 10g
retrieve records using the NATURAL JOIN and USING clauses.
retrieve data by creating joins with the ON clause.
use outer joins and generate Cartesian products.
use joins to retrieve data from multiple tables.
write SQL queries using set operators.
identify how to comply with rules for using set operators.
use the UNION, UNION ALL, INTERSECT, and MINUS operators in SQL queries
Course Number:216164_eng