Re: Generate a CRUD matrix
From: Tiago <diariodastrilhas_at_gmail.com>
Date: Fri, 15 Jan 2010 10:05:18 -0800 (PST)
Message-ID: <37255119-70b9-48ec-8390-56500aae83db_at_35g2000yqa.googlegroups.com>
On Jan 14, 2:23 pm, "Terry Dykstra" <tddyks..._at_forestoil.ca> wrote:
> Is it possible to extract a CRUD matrix for a procedure or package in
> Oracle. I'm using 10.2.0.4 SE.
> Getting a list off tables etc is easy enough to do using ALL_DEPENDENCIES,
> but I would like to know for each table whether the proc is updating,
> inserting etc.
>
> --
> Terry Dykstra
Date: Fri, 15 Jan 2010 10:05:18 -0800 (PST)
Message-ID: <37255119-70b9-48ec-8390-56500aae83db_at_35g2000yqa.googlegroups.com>
On Jan 14, 2:23 pm, "Terry Dykstra" <tddyks..._at_forestoil.ca> wrote:
> Is it possible to extract a CRUD matrix for a procedure or package in
> Oracle. I'm using 10.2.0.4 SE.
> Getting a list off tables etc is easy enough to do using ALL_DEPENDENCIES,
> but I would like to know for each table whether the proc is updating,
> inserting etc.
>
> --
> Terry Dykstra
Conquest's Clear SQL do what you want.
I'm not affiliated to these guys and this is not a free software, but has usable trial version.
http://www.conquestsoftwaresolutions.com/page/clearsql_pr_description
hth
- Tiago