Qualogy’s Tech Series with Patrick Barel: a collection is a collection, no matter how small

Webinar: a collection is a collection, no matter how small

Published on: Category: News

We are hosting a new series of live webinars: Qualogy’s Tech Series. Featuring weekly live webinars from a wide range of tech experts. The presentations can be followed via Zoom and start at 4:00 p.m. CET. On February 9, Patrick Barel presents ‘A collection is a collection, no matter how small’.

Abstract

Oracle Database provides us with collections since as long as I can remember (Oracle 7.3.6.4). First as PL/SQL Tables in PL/SQL only. They have been been renamed (Index-by Tables, Associative arrays) and new implementations have been added since (Varrays, Nested Tables [SQL and PL/SQL]). Also the original Associative arrays have been updated, making them available in SQL as well. They play a key role in many of the newer Oracle features like BULK Processing (BULK COLLECT and FORALL) and Table functions. Using the bulk processing capabilities of your Oracle Database they can speed up your processing by an order of magnitude.

This session will show a little bit of history, how to use the collections, how to make collections available in SQL so they can be processed in other languages. How things can be done in what version and how things become easier with the newer versions of the database.

About Patrick Barel

Patrick Barel is a PL/SQL Developer for Qualogy in the Netherlands. Besides working with SQL and PL/SQL he wrote different plug-ins for PL/SQL Developer. He publishes articles on his own blog.

In 2015 he received the Oracle Developer Choice Award in the PL/SQL Category. In 2019 he was promoted to Oracle ACE Director.

Connect with Patrick via Twitter | Blog | LinkedIn

Team Communication
About the author Team Communication

Innovative projects for great customers, inspiring interviews with colleagues and the latest news. Team Communication brings the Qualogy story to life and shares it with (business) relations, IT professionals and job applicants.

More posts by Team Communication
Comments
Reply