Oracle Application Express - how to import demo apex applications

What kind of applications could you build using Apex ?

The best way to find out what could you do with apex is to see the demo  apex application from Oracle. Oracle provide many demo Apex applicaiton at the website http://apex.oracle.com , It is really useful for beginners to download these apex demo applications and install it in your own development enviroment and play with it. This process is also called the import of Apex applications. Importing an existing Apex application is really easy. and require only a few steps.

Steps to import Apex Application

We will just have to go to Oracle Apex site to download an Apex demo and extract the archived file. It is typical that an Apex applications package contain only one sql file that contain all the definition and base data for the application. By the way, this feature also make Apex applicaton version control very easy cause all we have to do is to export the Apex applicaiton into one sql file and check in the sql file into our version control system.

The steps for importing apex applicaitons:

  1. Go to Apex development homepage and there 's one 'import' menu under the 'Application Builder' for importing Apex application.

  2. Then we will just have to select the sql file that contain the definition of the apex application.

  3. In the next step we will have to choose which database schema that our apex application is imported into.

  4. Just click the 'next' and 'next' button until we come to and click the 'install' button.

And We could return to the application home page and run the demo applicaiton now!