Re: find columns used in procedures

From: nullpointer <null_pointer_at_rediffmail.com>
Date: 17 Dec 2004 20:16:54 -0800
Message-ID: <1103343414.680969.147190@f14g2000cwb.googlegroups.com>

My problem is finding unused columns rather than unused tables. As mark said finding the tables is not a problem at all. Its the columns which are tricky.
Also dropping columns might not work because of the "SELECT * FROM table". It would still compile the PL/SQL but would break my app.

Still thinking

Regards
Dev

Mark D Powell wrote:
> Dennis, Why go to all that trouble when you can just query
> dba_dependencies to find the list of views, packages, functions,
stored
> procedures, and synonyms dependend on a table?
>
> HTH -- Mark D Powell --
Received on Fri Dec 17 2004 - 22:16:54 CST