Print
04
December
2008

Searching databse PL/SQL code for a string

The following query is useful if you want to know where certain tables, columns and expressions are referenced in your PL/SQL source code:

SELECT *
FROM user_source
WHERE UPPER(text) LIKE UPPER('%KEYWORD%');

Interested in building next-gen Big Data architecture? Join our webcast on 5/24 at 9am PT. Register here: http://t.co/k5Dsfskg

Oracle Oracle

#Oracle User Groups: Are You a Member Yet? Learn more about our 870 User Groups worldwide and become a member today: http://t.co/LsktPjH5

Oracle Oracle