sql11g_12 (1)

sql11g_12 (1) - Oracle11g SQL Chapter 12 Subqueries and...

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

View Full Document Right Arrow Icon
Oracle11 g : SQL Chapter 12 Subqueries and Merge Statements
Background image of page 1

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

View Full DocumentRight Arrow Icon
Objectives Determine when using a subquery is appropriate 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 2 Oracle 11g: SQL
Background image of page 2
Objectives (continued) 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 3 Oracle 11g: SQL
Background image of page 3

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

View Full DocumentRight Arrow Icon
Objectives (continued) 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 Use a subquery in a DML action Process multiple DML actions with a MERGE statement 4 Oracle 11g: SQL
Background image of page 4
Subqueries and Their Uses Subquery – a query nested inside another query
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/19/2010 for the course STA COMP 257 taught by Professor Bobbarlow during the Spring '10 term at Tampa.

Page1 / 29

sql11g_12 (1) - Oracle11g SQL Chapter 12 Subqueries and...

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

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