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.

Step by step guide to create "Aria Employee Directory Lookup" application in Oracle APEX

Oracle provides some pre-created applications in Oracle Application Express known as packaged applications. Packaged Applications are fully functional applications that you can view, use and customize. These packaged applications can be downloaded from Oracle's web site

Even if you download and use packaged application, sometimes and especially for beginners it becomes a challenge to really understand how these packages applications have been developed and decipher each and every component of it. This step-by-step guide is an attempt to address that problem, where you will recreate each any every component of the application yourself and have full understanding of it.

One of such packaged applications is “Aria Employee Directory Lookup”. Aria is used globally within Oracle to look up phone numbers, email addresses and other information about employees. Each employee can update his or her preferred contact information and upload an image for the employee profile page. Using this guide you will be able to create Aria Employee Directory Lookup application from scratch.

Once you have learnt Oracle Application Express, the next step is to put it to use. Training is necessary for getting the fundamentals right but there can be many challenges when you actually get down to create an application. Having a step-by-step guide that will walk to you through the different steps of how to create an actual application will give you an added advantage. It’s like taking an expressway to gain experience to develop real life applications.

Please do not forget to send your comments, feedback and suggestions to contact@dbcon.com . Please specify “Aria Employee Directory Lookup” in your subject line.

To use this guide effectively you must have the basic understanding of Oracle Application Express. If you are an absolute beginner in Oracle APEX we will highly recommend you to look at our training program “Developing Applications with Oracle Application Express” before you dive into this guide.

Aria Employee Directory Lookup Application - Step-By-Step Guide to create application in Oracle APEX

Publish at Scribd or explore others: How-to-Guides & Manu oracle application e oracle apex

Get Supporting Files

Like any other application, Aria Employee Directory Lookup is also dependent on other supporting objects. These support objects include

• Database Objects likes Tables, Indexes, Packages, Procedures, Functions, Sequences etc.
  
• Sample data in the tables
  
• Image Files
  
• Javascript Files
  
• CSS Files
  

In order to get started with the development of this application, you need to prepare your environment first. As our focus is just on creating the Aria Employee Directory Lookup application in Oracle APEX, a script has been provided to which will create all of the above mentioned supporting objects in your APEX workspace.

Click here to get the supporting files for Aria Employee Directory Lookup Application