Re: Generate a CRUD matrix

From: joel garry <>
Date: Thu, 14 Jan 2010 09:51:41 -0800 (PST)
Message-ID: <>

On Jan 14, 9:23 am, "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

The first thing that comes to mind is using a subquery to search user_source for the keywords for each matrix element, to limit the selection of user_source in a script that would otherwise print all procedures.


-- is bogus.
I have my Gumby and Pokey!
Received on Thu Jan 14 2010 - 11:51:41 CST

Original text of this message