Friday, April 24, 2009

How to find out what all database objects have been used in an APEX application

As your APEX application gets bigger and complex sometimes you may want to know what are the different database objects like tables, functions, procedures, sequences etc. that is being used by the application. You may want to have this information handy if you want to transfer your application from one environment to another (typically when you want to deploy application from test envrionment to production environment) or you may also want to have this information so that you can do a housekeeping of your database and remove all the unused objects.

"Database Object Dependencies" report in Oracle Application Express gives you exactly that information. Checkout in this less than 2 minutes video to see how you can extract this information.

(Don't forget to turn the volume up to listen to some nice music as you watch this)



If you are using highspeed broadband connection, select "720p" option in the toolbar to view the video in high definition (option will be visible once you play the video). Then click on "Full Screen" to view the video in crystal clear format.

0 comments: