Steven Feuerstein, Oracle Corporation
PL/Scope, first introduced in 11.1, offers a powerful code analysis tool, baked right into PL/SQL. With it, you can answer questions such as, "Where is this variable modified in my code?", "Which packages invoke a specific overloading of a function?" and "Show me all my unused declarations." Cool stuff. But prior to 12.2, SQL statements were not a part of that analysis. Now in 12.2, PL/Scope also gathers information about static SQL statements and where dynamic SQL is executed in your code. As a result, you can now use PL/Scope to perform comprehensive, detailed analysis of the impact of planned changes to your code base. In this webinar, Steven Feuerstein introduces attendees to PL/Scope, explores 12.2 enhancements, and provides scripts everyone can use to leverage PL/Scope in their dev environment.
Become a member of ODTUG to gain access to more than 12,500 files in our technical database.
- Not a member? Click through to the topic of interest to browse a list of available presentations.
- Already a member? Log-in here to access the full database
Click here to see the Full Techincal Resource Database