chap07 - Chapter 7 Subqueries Chapter 7 Introduction to...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 7 Introduction to Oracle9 i: SQL 1 Chapter 7 Subqueries
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 7 Introduction to Oracle9 i: SQL 2 Chapter Objectives Determine when it is appropriate to use a subquery Identify which clauses can contain subqueries Distinguish between an outer query and a subquery Use a single-row subquery in a WHERE clause Use a single-row subquery in a HAVING clause Use a single-row subquery in a SELECT clause
Background image of page 2
Chapter 7 Introduction to Oracle9 i: SQL 3 Chapter Objectives Distinguish between single-row and multiple- row comparison operators Use a multiple-row subquery in a WHERE clause Use a multiple-row subquery in a HAVING clause Use a multiple-column subquery in a WHERE clause
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 7 Introduction to Oracle9 i: SQL 4 Chapter Objectives Create an inline view using a multiple- column subquery in a FROM clause Compensate for NULL values in subqueries Distinguish between correlated and uncorrelated subqueries Nest a subquery inside another subquery
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 23

chap07 - Chapter 7 Subqueries Chapter 7 Introduction to...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online