plscope-utils for SQL Developer
|File size||17.0 KB|
plscope-utils simplifies common source code analysis tasks. This SQL Developer extension is based on PL/Scope and provides:
- A “PL/Scope” node in the Connections window.
- A “Compile with PL/Scope” context menu on the Connection and PL/Scope node.
- Detail viewers for tables, views, packages, procedures, functions, triggers, types and synonyms. These viewers are reachable via the appropriate nodes in the Connection window or via “Popup Describe” context menu when positioned on an identifier within a PL/SQL editor.
- A “plscope-utils Reports” folder within the Reports window.
All operations are based on objects available within an Oracle Database Server instance version 11.1 or higher. No database objects need to be installed for this extension. However, the majority of the queries require the “all_statements” view which is available since the Oracle Database version 12.2.
Compile with PL/Scope
Right click on the “Connection” or “PL/Scope” node in the Connection window to show the “Compile with PL/Scope” popup window.
The popup windows provides all relevant options for the Oracle Database version 12.2. However, if you are connected to an older version, just the applicable options are applied.
Viewers PL/Scope Node
The following screenshots show the available viewers for objects within the PL/Scope node. Every viewer has a column named “Link”. Click on this link to open the PL/SQL editor at the corresponding cursor position.
In the Reports window you find the “plscope-utils Reports” folder.
The following screenshots show an example for every report.
Duplicate SQL Statements
PL/SQL Naming Conventions
UDF Calls in SQL Statements
Unused Local Identifiers
Configure Update Center
Click the “Help” menu and select “Check for Updates…”. Press the “Add” button to register the update center http://update.salvis.com/ . If you have troubles to configure the proxy settings, because your company requires some additional authentication or similar, then I suggest to download plscope-utils for SQL Developer via the “Download” button below and use the “Install From Local File” option.