Oracle Apex - Application (flows)

Card Puncher Data Processing

About

An application is an HTML interface that exists on top of database objects such as tables or procedures

Identifier

ID

In the URL, the application number is the first number in the parameter sequence, followed by the page number (the f?p syntax section)

See the variable APP_ID

Alias

An alternate alphanumeric application identifier. You can use this identifier in place of the application ID. For example, suppose you create an alias of myapp for application 105. Using f?p syntax, you could call application 105 as either:

  • f?p=105:1
  • f?p=myapp:1

See the variable APP_ALIAS

Type

Using Application Builder you can create different types of applications:

Type Audience
Database applications developers
Websheet applications end users
Packaged Application developers

Database

A database application is a collection of pages.

Intern

Apex is developed with Apex and has then several application. The export files of this application are located in

Apex_Home\builder
Apex File Application
Id
Description
f4000.sql 4000 Oracle APEX AppBuilder
f4050.sql 4050 Oracle APEX Internal Administration
f4155.sql 4155 Scheme Authentication Login
f4300.sql 4300 Oracle APEX Data Workshop
f4350.sql 4350 Oracle APEX Workspace Administration
f4400.sql 4400 Oracle APEX Application Migration
f4411.sql 4411 Oracle APEX System Messages and Native Types
f4500.sql 4500 Oracle APEX SQL Workshop
f4550.sql 4550 Oracle APEX Login
f4600.sql 4600 Oracle Application Express Learn More
f4700.sql 4700 Oracle APEX New Service Signup
f4800.sql 4800 Oracle APEX Team Development
f4850.sql 4850 RESTful Services
f4900.sql 4900 Oracle APEX Websheets

For their installation, see Oracle Apex - Sample App

Metadata

The application metadata are stored in the wwv_flows table.

Example: All Interne Application:

select id, name from wwv_flows where id >= 4000 order by id;
ID NAME
4000 Oracle APEX AppBuilder
4050 Oracle APEX Internal Administration
4155 Scheme Authentication Login
4300 Oracle APEX Data Workshop
4350 Oracle APEX Workspace Administration
4400 Oracle APEX Application Migration
4411 Oracle APEX System Messages and Native Types
4500 Oracle APEX SQL Workshop
4550 Oracle APEX Login
4600 Oracle Application Express Learn More
4700 Oracle APEX New Service Signup
4800 Oracle APEX Team Development
4850 RESTful Services
4900 Oracle APEX Websheets
8950 Sample Database Application
8951 Collection Showcase





Discover More
Card Puncher Data Processing
Oracle Apex - Debug (Messages)

The debug facility displays application processing details through messages that can be: enabled (to a certain information ) disabled added removed See constant...
Oracle Apex Page Type
Oracle Apex - (Application) page

A page is the basic building block of an database application. Application pages share a common: session state and authentication. Individual pages are organized using containers called regions....
Card Puncher Data Processing
Oracle Apex - (Application|Page|Region|User) Cache

API See APEX_UTIL package: CACHE_GET_DATE_OF_PAGE_CACHE Function CACHE_GET_DATE_OF_REGION_CACHE Function CACHE_PURGE_BY_APPLICATION...
Oracle Apex Items Type
Oracle Apex - (Form|Page) (Field|Item)

An item (also called a field) is a HTML form elements such as text fields, select lists, and check boxes. Every item has a session state value that can be referenced by a variable. Item names...
Card Puncher Data Processing
Oracle Apex - Application items

Application items are not associated with a page but with an application and therefore have no user interface properties. You can use an application item as a global variable. Shares session state...
Oracle Apex Build Status
Oracle Apex - Build Status

“Build Status” is an application-level (scope) attribute. Build Status has two settings: Run and Build Application - Developers can both run and edit an application. Run Application Only - Developers...
Card Puncher Data Processing
Oracle Apex - Mail

Mail in Apex can be sen with the package. API The most efficient approach to sending email is to create a background job (using the DBMS_JOB or DBMS_SCHEDULER package) to periodically send all mail...
Oracle Apex Report Columns Metadata
Oracle Apex - Metadata

The metadata of Oracle Apex are stored in a schema prefixed with APEX. From this schema, you can query the whole application definition: from page to columns APEX_APPLICATION_ALL_AUTH APEX_APPLICATION_AUTH...
Oracle Apex Report Columns Metadata
Oracle Apex - Report Columns (RPT COLS)

Report Columns In the below example, the metadata query goes against the original tables. where: page_id is the page id and flow_id is the application id
Apex Sample Application
Oracle Apex - Sample App

Apex delivers Sample App with its own installation and as Apex itself is build in Apex, you can install it Apex is developed with Apex. You can then use it as a sample app. The application...



Share this page:
Follow us:
Task Runner