Re: Generate a CRUD matrix

From: Tiago <>
Date: Fri, 15 Jan 2010 10:05:18 -0800 (PST)
Message-ID: <>

On Jan 14, 2:23 pm, "Terry Dykstra" <> wrote:
> Is it possible to extract a CRUD matrix for a procedure or package in
> Oracle.  I'm using 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.


  • Tiago
Received on Fri Jan 15 2010 - 12:05:18 CST

Original text of this message