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
Oracle ACE
Philipp Salvisberg is a senior principal consultant, partner and member of the boards of directors at Trivadis and an Oracle ACE. He has been focusing on Oracle database based solutions since 1988. At that time with Oracle Database version 5. Since then, he is helping customers design, build and optimize their database centric 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 interested in pretty much everything 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