Development & Middleware
Wednesday, 18. October 2023., 15:00
Whether in classic database development or for the development of modern APEX applications, PL/SQL is a powerful and important tool. From simple help functions over complex calculations, extensive table APIs to multi-layer application logics, many problems can be solved with PL/SQL. There are often different ways to accomplish the goal. Although there are countless websites, guidelines, books, and online quizzes for PL/SQL, we always encounter don'ts and other pitfalls in the source code of our customers. In the database, this quickly impacts performance. Furthermore, poorly written code is often hard to understand and therefore hard to maintain.
The reasons are not only lack of knowledge, but often also lack of maintenance and insufficient time for refactoring. In this session, we will demonstrate how to transform bad (or sometimes just outdated) PL/SQL code into good code.
It's a mix of:
- our "best of" recurring mistakes and how to do it better,
- bad & best practice comparisons,
- tips & tricks
This talk is a discussion between two developers with lots of real-world examples, where the "most experienced" is not always right!