Databases Reference
In-Depth Information
To get an idea what APEX the product consists of, here are some figures from the Oracle website: APEX
consists of approximately 425 tables and 230 PL/SQL packages containing 425,000+ lines of code.
1-4. Familiarizing Yourself with APEX-speak
Problem
You find yourself amidst seasoned APEX developers. Tongue-tied, you strain your mind to make sense of
the jargon they're tossing across the table every minute or so. You don't speak APEX, and this is a serious
problem.
Solution
Before embarking on APEX, you need to know the difference between workspaces, Websheets, and
schemas. Table 1-2 explores in detail the various jargon used in APEX.
Table 1-2.
APEX Jargon
Jargon
Description
Workspace
A workspace represents the working area for a team
of developers. It allows different teams of
developers to work in their own separate workspaces
(in the same repository) and not have to interact
with each other.
Application
An application is basically what it sounds like—the
traditional notion of an “application.” In Apex
4.0, you can build two different types of
applications: a database application or a Websheet
application.
Database application
A database application is a type of application
built around an RDBMS. It typically consists of
forms, views, and reports.
Websheet application
The Websheet is the latest addition to Apex 4.0. It
is another type of application that lets you build
and deploy web-based forms, business logic, and
reports in a declarative manner.
Schema
Every APEX workspace is linked to one or more
database schemas. A database schema stores the
various database objects (such as tables) for each
application.
Theme
A theme is collection of templates that define the
look and feel (layout) of an APEX application.
