Oracle PL/SQL: Search PL/SQL for a string/ key value - This query is a useful way to find out where certain tables, columns and expressions are used in you

Quick Search:

Oracle PL/SQL: Search PL/SQL for a string/ key value

Jump to:

Snippet Name: Search PL/SQL for a string/ key value

Description: This query is a useful way to find out where certain tables, columns and expressions are used in your PL/SQL source code.

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 06th, 2009

SELECT TYPE, name, line
  FROM   user_source
WHERE  UPPER(text) LIKE UPPER('%&KEYWORD%');