A Gentle Introduction to Polymorphic Table Functions
Track
Development & Middleware
Date and time
Wednesday, 13. October 2021., 09:30
Room
Hall C
Duration
45'
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.
Lecture details
About speaker
Patrick Barel, author
Patrick Barel is a PL/SQL Developer for Qualogy [http://www.qualogy.com/] in the Netherlands. Besides working with SQL and PL/SQL he wrote different plug-ins [http://plugins.bar-solutions.com/] for PL/SQL Developer [http://www.allroundautomations.com/]. He publishes articles on his own blog [http://blog.bar-solutions.com/].In 2015 he received the Oracle Developer Choice Award in the PL/SQL Category.In 2019 he has been promoted to ACE Director.
The Best Sponsor
Educational Sponsor
Media Sponsor
HrOUG.hr
The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.