Presentation Title: Fighting Bad PL/SQL
Speaker: Mr Philipp Salvisberg
Company: Trivadis
Presentation abstract: 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.
Presentation begins: 04/12/2016 13:40
Presentation duration: 50
Presentation content level: 3 (1 = indepth, 5 = strategic overview)
Audience experience: Beginner/Exploratory
Audience function: Management, Product Expert, Product User, Systems Architect
Speaker biography:  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.
Related topics: APEX & Database Development: Development Practices/Tips , APEX & Database Development: PL/SQL , APEX & Database Development: Plug Ins , APEX & Database Development: SQL , APEX & Database Development: SQL Developer
Hall: Executive Room 8

fighting_bad_plsql.pdf2.5 MB01/12/2016 14:41:27