For decades it's been general good practice not to repeat identical code all over. In SQL the standard way to achieve this has for many years been to write a PL/SQL function and call it from your SQL statements. The challenge is making these function calls efficient. Oracle Database has many tools to help you with this. These include marking functions deterministic, SQL macros, and the latest enhancement, the SQL transpiler. With so many options available, how do you know which feature to use and when? Watch Chris and Kim as they take turns to optimize SQL calling PL/SQL. Learn about the issues with function calls from SQL and the pros and cons of the different ways to address this.
Highlights from this session include:
Share a link to this workshop via:
The QR code below is the URL for this workshop. Right-click to save the image to share with others.