Databases Reference
In-Depth Information
Figure 2-11.
The newly created customer record
How It Works
The Database Application type is the most common application type in APEX. It allows you to set up
pages (specifically forms and reports) that allow you to quickly generate the CRUD user interfaces
around an existing database table.
A typical APEX application starts off with the developer (or database designer) defining the full set of
database tables needed for the application. This can be done using the Object Browser tool or by
running PL/SQL script in the SQL Workshop section of APEX. It is also possible to create the database
objects—tables, indexes, constraints, sequences, etc.—using an external tool, a set of DDL in a script, or
importing the schema from another database.
Once the tables are all generated, the APEX developer generates the desired forms and reports from
the schema of these database tables. Once the forms are in place, the developer refines these generated
pages by adding validation routines, JavaScript functionality, complex form behavior, access rights
settings, and so on.
2-2. Creating a Report to Manage Your Data
Problem
Your users want to create two pages: a data entry form and another page to retrieve the data they have
just entered. The application also needs to display previously entered data to the users row by row in a
grid (listing) format and provide a way for them to edit and delete their data.
Solution
Execute the following steps to create a report to show existing records:
1.
Open the Sales Force application in the workspace (connected as a developer).
