Polymorphic Table Functions and Qualified Expressions

Session Number: 8079
Track: Database
Sub-Categorization: DB Dev
Session Type: Tips, Techniques and Tuning
Primary Presenter: Robert Marz [Technical Architect - its-people GmbH]
Time: Jun 25, 2019 (03:45 PM - 04:45 PM)
Room: 617, Level 6

Speaker Bio: Robert Marz is an Oracle ACE and member of Its-people GmbH, a German-based professional services company. At customer sites, Robert works as a senior technical architect with a database-centric view of the world. He is the portfolio manager of database technologies at Its-people.

At DOAG (the German Oracle user group), Robert is in charge of the cloud topics inside the database community. He is also a member of ODTUG, IOUG, and RMOUG. With more than twenty years of experience in custom development and data warehouse projects, Robert is a specialist in Oracle Database development and administration. Additionally, he is skilled in scripting languages, operating systems, virtualization, and cloud technologies.

Robert Marz publishes articles and papers in various publications, maintains the Its-people portfolio blog, and speaks frequently at German conferences.


Technologies or Products Used: Oracle 18c, PL/SQL

Session Summary for Attendees:  The most interesting new features Oracle 18c introduces to developers are Polymorphic Table Functions and Qualified Expressions. Polymorphic Table Functions finally allow the developer to define the structure of the returned records at runtime.

Qualified Expressions allow you to define array or record constructors that assign all values in a single statement. What looks at first sight like syntactical sugar is a mighty tool—especially in conjunction with Polymorphic Table Functions.
This talk introduces the concepts of Polymorphic Table Functions and Qualified Expressions and demonstrates real-world use cases and scenarios.

The presentation includes a detailed live demo.
The examples and scripts are available for download.