Oracle Application Express (5)

What is a Worksheet?

The term worksheet is confusing.  A worksheet is more like a web site or a workspace in a wiki site.

A worksheet is consistent of multiple pages.

A page can have multiple sections.

A section can show text, navigation links, data in a tabular format (Data Grid), or a chart.

Showing text is a normal function wiki page. Showing navigation links for a sections is like adding a TOC to a wiki page.

Adding a table (or data grid) is really the unique capability of APEX.

Objects of Worksheet

Types of Sections

 

Oracle Application Express(4)

Sample Applications

The best way to create a new apps is actually copying and modifying the sample apps.

People Search
Bug Tracker
Document Library

http://www.oracle.com/technetwork/developer-tools/apex/application-express/packaged-apps-090453.html

Oracle Application Express(3)

SQL Workshop

SQL Workshop is an existing web application available in the workspace.

It may confuse those people who do not have SQL background and do not know anything about database.

However, since the APEX service providers assume that the workspace users are database application developers., so it provides such applications.

Most database developers use some kind of the database client software, such as SQL Developer. However, I do not think that you are allowed to use the SQL developer to access the hosted APEX database. The SQL Workshop is provided for serving the purposes:

1. Create Tables and other objects (view, index, sequence, synonym, trigger, etc.)
2. Create PL/SQL package, function, or procedure.
3. Query the database

Oracle Application Express (2)

Application Workspace registration

You need to provide your name and your email during the registration.

Your email address will be used as the 1st user account that is assigned to this workspace.

Each workspace can have multiple users.

The user account created using the email address will be the workspace administrator.

You can create other users after you login.

However, the users created under the workspace are really the developers.

If people are just users of the applications, do not create them as users directly under the workspace.

Oracle Application Express (1)

You can get an account here:

apex.oracle.com.

It is a hosted service that allows you to create web applications.

All these applications are database applications.

Behind the scene, an Oracle database is there.

After you register, an Oracle database schema is created for your workspace.

The application modules are declarative apps. The metadata is, of course, stored in the database.

Continue: Oracle Application Express (2)