Managing the APEX Runtime Environment

You may start wondering how we can deploy applications and perform other administration tasks in an APEX Runtime Environment when there is no web interface to use. To perform these administration tasks, we can use Oracle SQL*Plus or Oracle SQL Developer. In this section, we will look at some common administration tasks and how they can be performed in an APEX Runtime Environment.

Note

Oracle SQL Developer is a free GUI-based tool for database development, similar to the SQL Workshop in APEX. It can be downloaded from the Oracle SQL Developer website:

http://www.oracle.com/technology/products/database/sql_developer/index.html

Installing applications

The most common administration task we need to perform when managing our environment is to deploy new or updated applications. In the previous chapter, we saw how to export our applications into a SQL script file. We can install our applications and other export files such as pages in an APEX Runtime Environment...