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, 2020

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.

Description

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
Catch up on the recording for our last session!
Don't miss our next live session!
This session: https://asktom.oracle.com/pls/apex/asktom.search?oh=10266

Session Resources

Your Experts

  • #SELECTION#
    Shashank Barki

    Shashank Barki   

    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.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Steven Feuerstein

    Steven Feuerstein   

    Steven Feuerstein is a Senior Advisor at Insum Solutions (https://insum.ca), 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!
    #MISC#
    #ACTIONS#

All Sessions

Resources