Forum Stats

  • 3,838,578 Users
  • 2,262,383 Discussions
  • 7,900,690 Comments

Discussions

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

bloggins
bloggins Member Posts: 21
edited Nov 8, 2018 3:54PM in SQL Developer

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

Tagged:

Answers

  • Unknown
    edited Nov 8, 2018 3:54PM

    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.