Upon completion of this course, the student will be able to: Create subqueries. Create queries using SET operators. Use common SQL *Plus file commands and SET commands to customize the SQL *Plus environment. Create a report using SQL *Plus format commands. Use the data dictionary tables and views.
Unit 1: Subqueries
- Subqueries: Overview
- Single and Multiple Row Subqueries
- Nested Subqueries
- Multiple Column Subqueries
- Subqueries with Comparison Operators
- Set Operators
Unit 2: SQL *Plus Commands
- SQL *Plus File Commands
- Formatting using SQL *Plus SET Commands
- Controlling Display using SQL *Plus SET Commands
Unit 3: Creating Reports
- SQL *Plus Format Commands
- Script Files
- Substitution Variables
Unit 4: Data Dictionary
- Oracle Data Dictionary Views
- Querying Oracle Data Dictionary