Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
Rights and permissions
Copyright information
© 2011 John Beresniewicz, Adrian Billington, Martin Büchi, Melanie Caffrey, Ron Crisco, Lewis Cunningham, Dominic Delmolino, Sue Harper, Torben Holm, Connor McDonald, Arup Nanda, Stephan Petit, Michael Rosenblum, Robyn Sands, Riyaj Shamsudeen
About this chapter
Cite this chapter
McDonald, C. (2011). Bulk SQL Operations. In: Expert PL/SQL Practices. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3486-9_6
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3486-9_6
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3485-2
Online ISBN: 978-1-4302-3486-9
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)