Enhance your Code with PL/Scope
For metadata fans like me a dream has come true with 12R2: PL/Scope can not only analyse identifiers within PL/SQL but also SQL statements inside your code, i.e. Tables, Views and their columns!
It is extremely easy to use, but what can developers actually do with this wealth of information it generates?
PL/Scope can support code analysis, checking/enforcing of coding guidelines, refactoring and optimising.
I will show
– how to query the metadata and how to combine it with other information from the data dictionary.
– how the PL/Scope information is already used within SQL Developer
– how we can also build our own reports with it
– how to use PL/Scope information inside an APEX application
Many demos and use cases will show the audience how to use this still widely unknown feature.
You can take the examples home and modify them to meet your needs.