Oracle Application Express provides you with all the tools you need to build apps in a single, extensible platform, which runs as a part of Oracle Database.
When you install Oracle Application Express, you can install either a runtime environment or a full development environment.
2.2.1 What is Oracle Application Express?
Oracle Application Express is a hosted declarative development environment for developing and deploying database-centric web applications. Thanks to built-in features such as user interface themes, navigational controls, form handlers, and flexible reports, Oracle Application Express accelerates the application development process.
The Application Express engine renders applications in real time from data stored in database tables. When you create or extend an application, Oracle Application Express creates or modifies metadata stored in database tables. When the application is run, the Application Express engine then reads the metadata and displays the application.
To provide stateful behavior within an application, Oracle Application Express transparently manages session state in the database. Application developers can get and set session state using simple substitutions and standard SQL bind variable syntax.
2.2.2 How Oracle Application Express Works
Oracle Application Express installs with your Oracle database and consists of data in tables and PL/SQL code. Whether you run the Oracle Application Express development environment or run an application built using Oracle Application Express, the process is the same. Your browser sends a URL request that is translated into the appropriate Oracle Application Express PL/SQL call. After the database processes the PL/SQL, the results are relayed back to your browser as HTML. This cycle happens each time you either request or submit a page.
Oracle Application Express does not use a dedicated database connection. Instead, each request is made through a new database session, consuming minimal CPU resources. Application session state is managed in the database tables by the Application Express engine.
Session state management
Page flow control
2.2.3 About the Differences Between Runtime and Full Development Environments
When you install Oracle Application Express, you can install two different environments:
Full development environment. In a full development environment, users can develop, modify, run, and delete Application Express applications. This option provides complete access to the Oracle Application Express environment described in this document.