Oracle Application Express is a rapid Web application development tool for the Oracle database. Using only a Web browser and limited programming experience, you can develop professional applications that are both fast and secure. 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.
From the end user's perspective, the deployed applications require only a browser and access to an Oracle database running Application Express.
Oracle Application Express installs with your Oracle database and is comprised of data in tables and PL/SQL code.
Whether you are running the Oracle Application Express development environment or an application you 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 request or submit a page.
The application session state is managed in the database tables within Application Express. It does not use a dedicated database connection. Instead, each request is made through a new database session, consuming minimal CPU resources.
The version of Oracle Database you use determines how the URL is translated:
- Versions before to Oracle Database 11.1 require Oracle HTTP Server (Apache) with
mod_plsql. The following illustration shows that architecture. - With Oracle Database 11.1 or higher or Oracle Database 10g Express Edition, you can remove Oracle HTTP Server (Apache) from the architecture and replace it with the embedded PL/SQL gateway. The following illustration shows the architecture using the embedded PL/SQL gateway.
- The embedded PL/SQL gateway provides Oracle Database with a Web server and also the necessary infrastructure to create dynamic applications. The embedded PL/SQL gateway runs in the XML DB HTTP server in the Oracle database and includes the core features of
mod_plsql, but does not require the Oracle HTTP Server powered by Apache. Inclusion of the embedded PL/SQL gateway simplifies the architecture and eliminates the middle tier.
The Application Express engine renders and processes pages. It also performs these tasks:
- Session state management
- Authentication services
- Authorization services
- Page flow control
- Validations processing
About the Oracle Application Express Environment
Oracle Application Express enables a single Oracle database to become a shared workgroup database service. Multiple users can access it using a Web browser without installing additional software.
About Workspaces
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.
In a typical development environment, you might create a single workspace for all your developers to share. However, you can also create dedicated workspaces for specific developers or projects. Creating a dedicated workspace limits access to the workspace objects to only those users associated with the workspace.
The following illustration shows the relationship among users and developers, workspaces, and database schemas.
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.
About Oracle Application Express User Roles
When setting up Application Express users at a large organization, you assign roles and privileges to specific users. The roles within Application Express include the following:
The following illustration shows multiple users with various roles accessing the Application Express development environment, Application Express Administration Services, and the published applications.
For this guide, you must have the privileges usually associated with three roles: Application Express Administrator, Workspace Administrator, and Developer. The following illustration shows an Application Express instance with a single user.
Thanks for sharing your informative article. As every business owner desire to be the part of digital marketing, there is massive demand for attractive and responsive website. It automatically increases the career prospects of web design and development professionals. Taking Web designing course in Chennai will help students to enter web design industry with good salary package.
ReplyDeleteThank you for this detailed article on Web designing institute in Chennai. I’m aspiring to do Web designing institute in Chennai.
ReplyDeleteWeb designing is the great technology to concentrate on. Thanks for sharing this worth able content in here.
ReplyDeleteweb designing institute in chennai
web designing courses
ReplyDeleteVery Clear Explanation. Thank you to share this
Regards,
PHP Training in Chennai | PHP Course in Chennai | PHP Training Institute in Chennai