CoderZone.org

Category: >> Oracle PL/SQL >> Search PL/SQL for a string/ key value Bookmark and Share

<< lastnext >>

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)

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

SELECT TYPE, name, line
  FROM   user_source
WHERE  UPPER(text) LIKE UPPER('%&KEYWORD%');
 
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 10