Re: Enumerate columns and tables in a query

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Wed, 14 May 2003 14:05:27 GMT
Message-ID: <3EC24BD1.DF5569A4@telusplanet.net>

Christophe Courtois wrote:

> Hi,
>
> I'm searching to get a list of columns and tables used in a query,
> including columns which appear in select, where, order by clauses, and
> before aliasing happens. (The goal is to search in a huge library of
> SQL scripts where some data is used. Scripts are already stored into
> the database as chars to make the search easier. )

Are you trying to do an impact-analysis type of thing? Eg. find out which scripts need to be changed, or which scripts use table xxx?

If so, why not evaluate the Enterprise Manager's Change Management Pack or the Oracle Development Suite's CVS-like capability - both do that intrinsically and may support your file types. Received on Wed May 14 2003 - 09:05:27 CDT