plscope-utils for SQL Developer

 

Version 0.6.0
Last Update 2017-10-09
File size 17.0 KB
Downloads 874

Introduction

plscope-utils simplifies common source code analysis tasks based on PL/Scope. This SQL Developer extension 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.

plscope-utils is licensed under the Apache License, Version 2.0. All sources are available at GitHub.

Examples

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 contains a column named “Link”. When you click on this link the PL/SQL editor will be opened and the cursor positioned on the appropriate line and column.

Identifiers

Statements

Uses

Used by

Table Usages

Column Usages

Reports

In the Reports window you find the “plscope-utils Reports” folder.

The following screenshots show an example for every report.

CRUD Operations

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.

salvis_update_center