Fighting Bad PL/SQL

Improving code is like losing weight. First, you need to know what is good and what is bad. To express your goals and achievements you need metrics and appropriate measuring instruments. Then you accomplish results as a series of small steps in the right direction. In PL/SQL the code complexity may be expressed in lines of code, in number of statements, as McCabe’s cyclomatic complexity, as Halstead volume or as maintainability index. After this session you know the pros and cons of each of these metrics and how to calculate them within SQL Developer with two mouse clicks. Most importantly you know how to find and eliminate bad PL/SQL.

Donnerstag, 17.11.2016
10:00 - 10:45

Philipp Salvisberg

Trivadis AG
Philipp Salvisberg is a senior principal consultant, partner and member of the boards of directors at Trivadis. He has been focusing on Oracle database based solutions since 1988 at that time with version 5. Since then he is helping customers to design, build and optimise their Oracle based solutions, teaching application development topics or speaking at conferences. Philipp has a soft spot for doing as much as possible in a single SQL statement and is very much interested in Oracle’s SQL and PL/SQL capabilities to use the database as efficiently as possible. He likes to design model-driven software solutions using domain specific languages while getting the most out of the underlying technologies.

Weitere Vorträge von Philipp Salvisberg

oddgen - An Introduction
Tuesday , 15.11.2016
08:30 - 09:15

Weitere Vorträge, die Sie interessieren könnten