plscope-utils for SQL Developer

 

Version 0.6.0
Last Update 2017-10-09
File size 17.0 KB
Downloads 1,515

Introduction

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.

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.

plscope-utils - Compile with PL/Scope

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.

plscope-utils - Compile Options

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.

Identifiers

plscope-utils - Identifiers

Statements

plscope-utils - Statements

Uses

plscope-utils - Uses

Used by

plscope-utils - Used by

Table Usages

Table Usages

Column Usages

plscope-utils - Column Usages

Reports

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

plscope-utils - Reports

The following screenshots show an example for every report.

CRUD Operations

plscope-utils - CRUD Operations

Duplicate SQL Statements

plscope-utils - Duplicate SQL Statements

PL/SQL Naming Conventions

plscope-utils - Overriding Naming Convention Rules

plscope-utils - PL/SQL Naming Conventions

UDF Calls in SQL Statements

plscope-utils - UDF Calls in SQL Statements

Unused Local Identifiers

plscope-utils - 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.

plscope-utils - Installation