O'Reilly logo

OCA Oracle Database SQL Expert Exam Guide by Steve O'Hearn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

15Manipulating Large Data Sets

CERTIFICATION OBJECTIVES

15.01 Manipulate Data Using Subqueries

15.02 Describe the Features of Multitable INSERTs

15.03 Use the Following Types of Multitable INSERTs: Unconditional, Conditional, and Pivot

15.04 Merge Rows in a Table

15.05 Track the Changes to Data over a Period of Time

Image Two-Minute Drill

Q&A Self Test

This chapter looks at a variety of features and operations that are useful for working with large groups of data. Many of these features combine SQL statements we’ve already reviewed, but in this chapter we look at new combinations of these features, and new keywords and clauses to broaden capabilities ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required