plscope-utils

Introduction

plscope-utils is based on PL/Scope which is available in the Oracle Database since version 11.1. It consists of the following two components:

• Core Database Objects

  Provides relational views and PL/SQL packages to simplify common source code analysis tasks. Requires a server side installation.

• SQL Developer Extension (plscope-utils for SQL Developer)

Extends SQL Developer by a PL/Scope node in the database navigator tree, context menus, views shown for tables, views and PL/SQL nodes and some reports. Requires a client side installation only.

Part of plscope-utils is a check of naming conventions according to this coding guideline - either as a database view or a Oracle SQL Developer report.