What if the from clause uses synonyms ?=20 -----Original Message----- solbeach@xxxxxxx This can "easily" be done using PERL & SQL-Statement plugin. (Nothing is impossible for the person who does not have to do it!) SQL-Statement is a SQL parser which can be used to ID the tables in the FROM clause. >=20 > From: Mike Schmitt <mschmitt@xxxxxxxxxxxx> >=20 > dba_dependencies tells us which tables that a package touches. However, a=20 > package might consist of 20 separate procedures. We have been asked to find=20 > out what tables each procedures of a package reference. >=20 > for example: >=20 > test.proc1 references tables: emp, department, region > test.proc2 references tables: emp > test.proc3 references tables: region, department ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------