Re: SQL + PL/SQL free impact analysis tool ?
From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 09 Oct 2002 20:28:09 GMT
Message-ID: <3DA49137.E1FEA376_at_exesolutions.com>
Date: Wed, 09 Oct 2002 20:28:09 GMT
Message-ID: <3DA49137.E1FEA376_at_exesolutions.com>
guy.dallaire-nospam_at_criq.qc.ca wrote:
> Is there a free tool that could analyze PL/SQL and/or SQL code (Eg: a
> script) and that would tell you (This is an example)
>
> This code xyz/procedure/package/script is accessing the following
> objects:
>
> calls procedure x, funtion y,
> inserts in table abc,
> updates tables z,y,z,
> deletes tables h,j,d
>
> Some kind of impact analyzis
>
> Thanks
>
> Note: Please remove -nospam from my e-mail address to reply
Anything wrong with the following?
SELECT *
FROM all_dependencies
WHERE ....;
Daniel Morgan
Received on Wed Oct 09 2002 - 22:28:09 CEST