Oracle Application Express is a rapid Web application development tool for the Oracle database.
Oracle Application Express installs with your Oracle database and is comprised of data in tables and PL/SQL code.
The application session state is managed in the database tables within Oracle Application Express. It does not use a dedicated database connection. Instead, each request is made through a separate database session, consuming minimal CPU resources.
In order to run, Oracle Application Express must have access to Oracle Application Express Listener, Oracle HTTP Server and mod_plsql, or the embedded PL/SQL gateway.
The embedded PL/SQL gateway installs with in the Oracle database. It provides the Oracle database with a Web server and also the necessary infrastructure to create dynamic applications. The embedded PL/SQL gateway runs in the Oracle XML DB HTTP server in the Oracle database and includes the core features of mod_plsql.
ApEx embeded PL/SQL gateway
lub architektura three-tier:
ApEx in three tier architecture
The area where you develop applications is called a workspace.
A workspace is a virtual private database that enables multiple users to work within the same Oracle Application Express installation while keeping their objects, data, and applications private.
ApEx workspace
When you create a workspace, you associate it with a new or existing schema. A schema is a logical container for database objects such as tables, views, and stored procedures. A single schema can be associated with one or more workspaces.
The roles within Oracle Application Express include the following: Workspace administrators, Developers, End users, Instance administrators (manage an entire hosted instance using the Application Express Administration Services application)
Logging In to Administration Services
http://hostname:port/apex/apex_admin (port 8080)
port is the port number assigned to Oracle HTTP Server. In a default installation, for Oracle WebLogic Server this number is 7001, in OC4J this number is 8888, in Oracle Glassfish Server this number is 8080.
ApEx Workspace creation.
If you want to use the same name for both your workspace and schema, enter a workspace name that contains only alphabetic characters. Schema names are restricted to alphabetic characters.
Workspace ID – Leave Workspace ID blank to have the new Workspace ID automatically generated. A Workspace ID must be a positive integer greater than 100000
ApEx Workspace creation.
ApEx Workspace creation.
ApEx Workspace creation.
ApEx Workspace creation.
Źródła:
http://download.oracle.com/docs/cd/E17556_01/doc/appdev.40/e15516/toc.htm