Code Library - Oracle Live SQL

Skip to Main Content

Script
12.2: Find duplicate SQL statements with PL/Scope

PL/Scope is a compiler tool that gathers information about identifiers (as of 11.1) and SQL statemen...

impact, change,duplicate

5 76

8.2 years ago Steven Feuerstein
Script
PL/Scope Examples

PL/Scope is a powerful code analysis tool, built into PL/SQL. Before compiling your program units, t...

PL/SCOPE,CODE ANALYSIS

7 72

9.2 years ago Steven Feuerstein
Script
PL/Scope Helper Package

PL/Scope is a powerful code analysis tool built into the PL/SQL compiler. This package helps you get...

CODE ANALYSIS,PLSCOPE

4 38

9.5 years ago Steven Feuerstein
Script
12.2: PL/Scope Now Analyzes SQL Statements!

PL/Scope is a powerful code analysis tool for PL/SQL program units, first introduced in Oracle Datab...

PL/Scope,impact analysis

4 31

8.3 years ago Steven Feuerstein
Script
Find COMMITs and ROLLBACKs in Code with PL/Scope 12.2

With 12.2's enhancement to PL/Scope to also gather data on SQL statements in your PL/SQL code, it's ...

pl/scope,scope,analysis

0 13

7.9 years ago Steven Feuerstein
Script
12.2: Use PL/Scope to Find All SQL Statements with Hints

As of 12.2, PL/Scope now analyzes the static SQL statements that appear in your PL/SQL program units...

hint,plscope

0 13

8.2 years ago Steven Feuerstein
Script
IDENTIFY_MODULE - find module (procedure or function) name based upon line number using PL/SCOPE

Demo of a function IDENTIFY_MODULE to fetch submodule name in a package body based upon line number ...

PL/SCOPE, package body, name of submodule, plsql

0 8

6.9 years ago Sven Weller

row(s) 1 - 7 of 7