September 2004
Intermediate to advanced
448 pages
8h 49m
English
Content preview from Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007)Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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, ...