Oracle Application Express
Return to Oracle APEX Home
Application Express and Oracle Database XE

Oracle Database 10g Express Edition (Oracle Database XE) includes Oracle Application Express (Oracle APEX) release 2.1, a declarative, graphical development environment for creating database-centric Web applications. Oracle APEX is installed in Oracle Database XE as the primary tool for managing the database and building Web-based applications. The majority of the administration tasks of Oracle Database 10g Express Edition can be performed using the administrative features of Oracle APEX, such as monitor database activity and manage database users, storage, memory and database objects. The simple Web-based interface enables users with minimum Oracle experience to easily manage the database. Application Express is pre-installed and fully configured, and it is immediately available after installation of Oracle Database 10g Express Edition.

Oracle Application Express 2.1 is different from the standard release of Application Express 2.0. Following is the list of major differences:

  1. All users are authenticated using database credentials. Workspace authentication is not available.
  2. Database roles are observed for all SQL issued within Application Express.
  3. New application authentication scheme, Database Account, can be used to create applications which use the native database credentials for authentication.
  4. New Online Help user interface — Procedural Help in Oracle APEX 2.1 features an improved user interface. You can browse through topics using an expandable table of contents. In addition, each help topic includes a breadcrumb trail at the top of each page. Online help includes content from the following sources: Application Express User’s Guide, 2 Day Developer, 2 Day DBA.
  5. After installation, Oracle APEX is accessible only from the computer Oracle Database XE is installed. An administrator can enable the Database Home Page for remote users.
  6. Service Administration is not available. The concept of hosting Oracle APEX service not available in this version of Oracle APEX. To host an Application Express instance for many users across multiple workspaces, the database will need to be upgraded to Oracle Database 10g Enterprise Edition or Standard Edition.
  7. Applications exported from Oracle APEX 2.1 can be imported to HTML DB 2.0 or higher.
  8. Oracle APEX is configured with the XDB HTTP Server and embedded PL/SQL gateway in Oracle Database XE. There is no need for a separate installation of Oracle HTTP Server and modplsql.
  9. The home page (Oracle Database XE Home Page) has a different layout as follows:
    • Administration — Manage database user accounts, manage memory, storage, and network access, monitor database activity, and view configuration information.
    • Object Browser — View, create, modify, browse, and drop database objects. Use the PL/SQL editor to edit and compile packages, procedures, functions, and other types of database objects.
    • SQL — Access the following SQL tools:
      • SQL Commands — Run SQL commands and anonymous PL/SQL blocks. Run scripts and saved queries.
      • SQL Scripts — Create, edit, view, run, and delete script files. Upload and download scripts from your local file system.
      • Query Builder — With little or no SQL knowledge, build SQL queries using a graphical user interface. View formatted query results and save queries.
    • Utilities — Load and unload data, generate DDL, view object reports, and restore dropped database objects.
    • Application Builder — Easily create a fully functional HTML application on top of database objects such as tables and procedures. View applications, perform application administration, and export or import an application.
    • Usage Monitor — The Usage Monitor appears on the right side of the home page and displays as horizontal bar graphs the following two metrics: the amount of space available in your database, and current memory allocation. In addition, beneath the bar graphs, the Usage Monitor shows the current number of database sessions (active and total), and number of database users (internal, database, and total), and whether Log Archiving (ARCHIVELOG mode) is on or off.
  10. Administrative features added as follows:
    • Database Users — Create, view, alter, and drop database users. Grant roles and system privileges to users. Lock and unlock users. Expire a user’s password.
    • Storage — Monitor the amount of storage used and how much remaining storage is available. If the remaining space is low, storage can be compacted. Compacting storage attempts to recover unused fragmented free space in the database. Also, information and the status of the online redo log files can be reviewed.
    • Memory — View current memory allocation, and change System Global Area (SGA) and Program Global Area (PGA) sizes.
    • Manage HTTP Access — Control HTTP access to the database. After installation, Oracle APEX is accessible only from the local computer where Oracle Database XE is installed. Access for remote users may be enabled through this page.
    • Manage Login Message — Control the message displayed on the login page.


Left Curve
Popular Downloads
Right Curve
Untitled Document