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 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


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 is a Senior Advisor at Insum Solutions (, and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). You will find an abundance of quizzes from Steven at the Dev Gym. Enjoy!