Skip to Main Content

Explore Oracle PL/SQL

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

November 10

16:00 - 17:00   Start Times Around the World


Tips for Analyzing PL/SQL Code
How do you deal with PL/SQL code maintenance and code analysis ? An effective code management strategy emphasizes code tracing, profiling, testing and reporting. In this session, Shashank Bark returns to offer best practices and useful techniques to analyze PL/SQL code using various data dictionary views, initialization parameters, and built-in packages.

1. Tracking exceptions in PL/SQL code
2. Tracing and generating reports on PL/SQL source code using DBMS_METADATA package
3. PL/Scope toola
4. Getting the most out of DBMS_UTILITY.FORMAT_CALL_STACK

Your Experts

Shashank Barki
Shashank Barki, Senior Principal Data Engineer
Shashank is a Senior Principal Data Engineer at Manhattan Associates. He has 13 years experience as a developer, cloud architect and data analyst. In each of his jobs, he has promoted the use of PL/SQL to improve the performance, security and maintainability of their applications.
Steven Feuerstein
Steven Feuerstein, Developer Advocate for PL/SQL    
Steven Feuerstein leads a team of Developer Advocate at Oracle Corporation, and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). He's published over 1400 quizzes on PL/SQL at the Oracle Dev Gym.