How to transfer bad PL/SQL into good


Development & Middleware

Date and time

Wednesday, 18. October 2023., 15:00


Hall B



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!

Lecture details

Level of difficulty: General
Desirable listeners function: Developers
Group of activity: Development & Middleware

About speaker

T-Shirt Sponsor

Venue Sponsor

Media Sponsor

The conference is organized by the Croatian Association of Oracle users. More about the association can be found at

Linkedin HrOUG

Follow us on Linkedin

Follow us on Twitter

Follow us on Facebook