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. > > From: Mike Schmitt <mschmitt@xxxxxxxxxxxx> > Date: 2004/06/30 Wed PM 05:17:15 EDT > To: oracle-l@xxxxxxxxxxxxx > Subject: Procedures within Packages > > > > Hi all, > > dba_dependencies tells us which tables that a package touches. However, a > package might consist of 20 separate procedures. We have been asked to find > out what tables each procedures of a package reference. > > for example: > > 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 -----------------------------------------------------------------