A Gentle Introduction to Polymorphic Table Functions

29 Jan 2019
10:15 - 11:00

A Gentle Introduction to Polymorphic Table Functions

Oracle database 18c introduces Polymorphic Table Functions. This session will tell you about Polymorphism and how you could apply this in pre-18c databases. After this session you will understand when to use which technique.

Oracle database 18c introduces Polymorphic Table Functions. This session will tell you about Polymorphism. How can you apply this in pre-18c databases? I will show you what problem and the solution when your data or structure changes. I will also show you an example of a Polymorphic Table Function and how this can help protect you from changing table structures and how you can apply the same code to different table structures without changing or even recompiling the code. After this session you will understand when to use which technique.