O'Reilly logo

OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) 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

Images

13

Manipulating Large Data Sets

CERTIFICATION OBJECTIVES

13.01     Describe the Features of Multitable INSERTs

13.02     Merge Rows into a Table

   ✓        Two-Minute Drill

Q&A     Self Test

This chapter looks at features and operations that are useful for working with large groups of data. We cover two operations in particular. The first consists of additional features to the INSERT statement that enable you to use one INSERT statement to add multiple rows of data to a given table or to several tables, with and without conditional logic. Later in the chapter we’ll cover the SQL statement MERGE, which is a powerful statement that enables you ...

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