Generate a CRUD matrix
From: Terry Dykstra <tddykstra_at_forestoil.ca>
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 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.
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 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 DykstraReceived on Thu Jan 14 2010 - 11:23:07 CST