How to transfer bad PL/SQL into good
Track
Development & Middleware
Date and time
Wednesday, 18. October 2023., 15:00
Room
Hall B
Duration
45'
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
About speaker
Maik Becker, author
Maik has 20+ years of experience in software development. Since more than 10 years he has been working with Oracle database and became an APEX enthusiast over the years.
As Business Unit Manager at TRIOLOGY, a midsize IT-Consulting company located in Germany, he is responsible for the Data Consulting unit, including the Oracle Database and Application Express team.
With his passion for Oracle APEX he is always focused on the business cases of his customers.
Maik shares his knowledge writing articles and blogs and he is a trainer and speaker at several conferences, like APEX Connect, DOAG Conference, APEX Alpe Adria and others.
He is organizer of the APEX Meetup Braunschweig as well as an active member at DOAG. Since 2023 Maik is member of the APEX Connect committee. At the same time, he was awarded by the Oracle ACE Program.
He never gets tired motivating young developers for database development and the Oracle development stack.
Alexandra Welzel, coauthor
Alexandra has been working as Database Developer at TRIOLOGY GmbH in Germany for a couple of years.
She is focused on the Oracle Database and on delivering applications using Oracle APEX and PL/SQL. Alexandra is also involved in the education of Database Development at TRIOLOGY and she is sharing knowledge at several conferences.
T-Shirt Sponsor
Venue 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.