RMOUG Training Days 2019

Conference Session

The most interesting new features Oracle 18c offers for 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 allows defining array—or record constructors that assign all values in a single statement. What looks at first sight as 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 with a detailed live demo. The examples and scripts will be available for download.