Skip to Content
Beginning Oracle® Application Express
book

Beginning Oracle® Application Express

by Dan Wood, Chris Leiter, Paul Turley
December 2008
Intermediate to advanced
383 pages
9h 14m
English
Wrox
Content preview from Beginning Oracle® Application Express

10.2. Structure of the APEX Environment

The next main topic to cover is to learn how to deploy your completed application. You are already familiar with the various components of an APEX application, but to fully understand deployment options, you should fully understand the structure of the APEX environment.

As you already know, APEX applications run on an Oracle database. In fact, the APEX environment can be understood as a hierarchy of environments, as shown in Figure 10-3.

Figure 10-3. Figure 10-3

At the top level is the Oracle database instance. An Oracle instance is the entire world, the runtime environment of the Oracle database. When a user connects to any application in any workspace, or data in any schema, they are connecting to the Oracle instance. The Oracle instance contains the common systems, such as SQL parsers, the PL/SQL runtime environment, the overall security system and the network software which handles client connections.

Within the Oracle instance are individual APEX workspaces. An APEX workspace is like a virtual private database, fencing off all the information within the workspace from unauthorized access. A workspace can contain one or more applications, as well as shared objects that are used by one or more applications within the workspace. APEX users are also defined within a workspace, as you did in Chapter 9 on security.

An APEX application is ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Beginning Oracle Application Express 5

Beginning Oracle Application Express 5

Doug Gault
Pro Oracle Application Express

Pro Oracle Application Express

John Edward Scott, Scott Spendolini

Publisher Resources

ISBN: 9780470388372Purchase book