O'Reilly logo

Expert PL/SQL Practices for Oracle Developers and DBAs by Riyaj Shamsudeen, Robyn Sands, Michael Rosenblum, Stephan Petit, Arup Nanda, Connor McDonald, Torben Holm, Sue Harper, Dominic Delmolino, Lewis Cunningham, Ron Crisco, Melanie Caffrey, Martin Büchi, Adrian Billington, John Beresniewicz

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

C H A P T E R  6

Bulk SQL Operations

by Connor McDonald

This chapter is about the bulk SQL operations available in PL/SQL. Bulk operations in PL/SQL enable you to manipulate and process many rows at once, rather than one row at a time. In this chapter, you’ll learn about bulk fetching and bulk binding. Bulk fetching refers to the ability to retrieve a set of rows from the database into PL/SQL structures with a single call, rather than making a call to the database for each row to be retrieved. Bulk binding lets you perform the converse: to take those sets of rows stored in PL/SQL structures and save them to the database in an efficient manner.

You’ll see the tremendous performance benefits possible with bulk SQL operations. To achieve these ...

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