Monday, September 21, 2009

How to Find a string in plsql code

How to know where certain tables, columns and expressions are referenced in your
PL/SQL source code.


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

No comments: