PL/SQL Collections

Held on August 7 2018

Collections are PL/SQL's version of arrays and there are three types: associative arrays, nested tables, varrays. They are used in many performance features of PL/SQL, such as bulk processing, as well as table functions. Steven Feuerstein uses them all the time and thinks you should, too. He kicked off this Office Hours with some of his favorite collections features/usages, and then he and Chris Saxon answered questions on measuring PGA, executing DML in parallel, and more.

2:30 Steven's favorite collection things
3:20 First a little quiz!
7:56 Banish row-by-row SQL processing
14:06 String-indexed collections
17:19 Nested collections
20:42 Table functions
26:18 Q&A

AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.

https://asktom.oracle.com/

Oracle Developers portal: https://developer.oracle.com/
Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit


music: bensound.com

• #science_technology
• #oracle
• #oracle_cloud
• #oracle_developers
• #cloud
• #cloud_computing
• #platform
• #infrastructure
• #database
• #plsql
• #sql
• #collection
• #array