Understanding and Using PL/SQL Arrays and Bulk Processing
PL/SQL is Oracle's procedural language extension to SQL. It is functionally similar to SQL Server and Sybase's Transact SQL, but much more powerful.
The strength of PL/SQL and similar language extensions to SQL is that they are much more flexible than SQL. Their weakness is their performance. Oracle has addressed this weakness via PL/SQL's support of PL/SQL Arrays and Bulk Processing.
For many applications traditional PL/SQL requires us to process one row at a time. With Arrays and Bulk Processing many of these same applications can be easily rewritten to process many rows at a time. Additionally, Arrays allow us to build in-memory tables which are designed to avoid repeated SQL queries. Both techniques can lead to significant improvement in PL/SQL performance.
In this presentation we review various scenarios where PL/SQL is required. We then demonstrate the traditional PL/SQL solutions, and how to convert the traditional slower PL/SQL code to much faster code using PL/SQL Arrays and Bulk Processing.
Presenter: Geoff Wiland
Oracle Database Performance Tuning Training. Oracle SQL Tuning Training.Instructor-led. Real-world. By example.
Learn more about SkillBuilders Oracle training.