|
This course provides an in-depth look at using subqueries and views in Oracle9i SQL.
Objectives:
After completing this course, students will be able to:
- List the types of subqueries
- Use subqueries in Oracle SQL commands
- Add and drop views
- Change views
- Modify data using views
Topics:
- Subqueries
- Types and uses of views
- Simple, constraint and complex views
- Changing and dropping views
- Working with views
- Inserting, updating and deleting in views
|