Chapter 8. Subqueries and Other Specialized Queries
Terms You Need to Understand
✓ Subquery
✓ Scalar subquery
✓ Single row subquery
✓ Multiple row subquery
✓ Multiple column subquery
✓ Correlated subquery
✓ Regular subquery
✓ Inline view
✓ Nested subquery
✓ Composite query
✓ Hierarchical query
✓ Parallel query
✓
Flashback query✓
The WITH clause
Concepts You Need to Master
✓ Different types of subqueries
✓ Where subqueries can be used
✓ Set operators
✓ Hierarchical query operators
✓ Subquery comparison conditions
This chapter covers all the aspects of subquery processing, ...
Get Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
