Generate a CRUD matrix

From: Terry Dykstra <>
Date: Thu, 14 Jan 2010 17:23:07 GMT
Message-ID: <%pI3n.59666$Db2.11147_at_edtnps83>

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 
Received on Thu Jan 14 2010 - 11:23:07 CST

Original text of this message