looking for info on triggers, procedures, functions, & code used

bloggins

Given that I can use the Data Modeler tool to show the metadata for the database tables, I need to know the code/functions/procedures/triggers that may affect how the database tables are actually used by applications/systems. I'm looking at groups of applications/systems based on installed databases (little documentation available, not up to date either). Any suggestions for how to use Oracle Developer or related tools for this?

Thanks very much

Unknown

You will have to do code review of all of the code.

The source code should already be in a version control system so just check the code out and review it.

You can use sql developer to extract the DDL (export wizard) if you need to.