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

• #science_technology
• #groundbreakers
• #oracle_cloud
• #oracle_developers