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

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

Gepubliceerd: Categorie: Nieuwsblog

We organiseren een nieuwe reeks live webinars: Qualogy’s Tech Series. Met wekelijks een live webinar van een tech-expert. De presentaties zijn via Zoom te volgen en starten om 16.00 uur. Woensdag 9 februari geeft Patrick Barel zijn presentatie ‘A collection is a collection, no matter how small’.

Let op: de presentatie van Patrick is in het Engels.

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
Over auteur Team Communication

Innovatieve projecten voor mooie klanten, inspirerende interviews met collega’s en het laatste nieuws over behaalde successen. Qualogy zit vol bijzondere verhalen die Team Communication graag deelt met relaties, IT-professionals en sollicitanten.

Meer posts van Team Communication
Reacties
Reactie plaatsen