Oracle Database 2 Day + Application Express Developer's Guide contains a series of tutorials that explain how to use Oracle Application Express to create applications and application components. The goal of this book is to help you understand how to use Oracle Application Express through hands-on experience.
This section contains the following topics:
Oracle Database 2 Day + Application Express Developer's Guide contains ten tutorials with step-by-step instructions. The objective of these tutorials is to demonstrate how to build a particular type of application or application component using the Oracle Application Express development environment.
Where appropriate, this book describes concepts relevant to understanding or completing a task. However, this book is not intended to be a complete discussion of Oracle Application Express concepts. For this type of information see Oracle Application Express online Help or Oracle Database Application Express User's Guide.
Prior to completing these tutorials, please review:
"Quick Start" in Oracle Database Application Express User's Guide.
"Application Builder Concepts" in Oracle Database Application Express User's Guide.
"Using Application Builder" in Oracle Database Application Express User's Guide.
This document contains the following tutorials:
| Title | Description |
|---|---|
| How to Create a Tabular Form | Illustrates how to create a tabular form within a new application and how to change one of the updatable columns from a text field to a select list. |
| How to Create a Parameterized Report | Illustrates how to create a report based on a SQL query that references the value of a form item within the application. |
| How to Create a Drill Down Report | Describes how to create a report on a table that contains drill down links to details in another report. |
| How to Control Form Layout | Explains how to create a data input form and then change the form layout by editing the region and item attributes. |
| How to Work with Check Boxes | Illustrates the different ways in which you can create and process check boxes within an application. |
| How to Implement a Web Service | Explains how to call a Web service from within an Oracle Application Express application. |
| How to Create a Stacked Bar Chart | Explains how to create a stacked bar chart within an application. |
| How to Upload and Download Files in an Application | Illustrates how to create a form and report with links for file upload and download. |
| How to Incorporate JavaScript into an Application | Describes some usage scenarios for JavaScript and includes details about how to implement them in your application. |
| How to Build and Deploy an Issue Tracking Application | Provides step-by-step instructions on how to create and deploy an application that tracks the assignment, status, and progress of issues related to a project. |
Many of the tutorials in this book utilize database objects in a fictional Human Resources department. These tables are set up to track information about the employees and the facilities where they work.
Each employee has an identification number, email address, job identification code, salary, and manager. Employees are assigned to a department and each department is associated with one location that has a full address that includes the street name, postal code, city, state or province, and country code.Before you can complete the tutorials that require the HR database objects, you need to run a script to create them in a schema that you can access. You can run this script by downloading a script file from OTN and then uploading it to the Script Repository.
Note:
You can also create scripts manually in the Script Editor, which you do as part of the exercises in "How to Build and Deploy an Issue Tracking Application".To download the hr_schema_create.sql script from OTN:
In your Web browser go to:
http://www.oracle.com/technology/products/database/application_express/code/hr_schema_create.sql
Download the file to your computer.
Tip:
You can remove the sample HR database objects from your workspace by running thehr_schema_drop.sql file. To download hr_schema_drop.sql go to:
http://www.oracle.com/technology/products/database/application_express/code/hr_schema_drop.sql
To upload hr_schema_create.sql script to the Script Repository:
Log in to Oracle Application Express. See "Logging In To Oracle Application Express" in Oracle Database Application Express User's Guide.
On the Workspace home page, click SQL Workshop and then SQL Scripts.
The SQL Scripts page appears.
Click the Upload button.
On the Upload Script page:
Click Browse and select the hr_schema_create.sql script file you just downloaded.
In Script Name, enter Create HR Objects.
Click Upload.
The Create HR Objects script appears.
Click the Create HR Objects icon.
The Script Editor appears.
Click Run.
A summary page appears.
Click Run again.
The Manage Script Results page displays a message that the script has been submitted for execution.
The Application Builder installation includes a number of demonstration applications. You use one of the demonstration applications, called Sample Application, to do several exercises in the tutorials. Therefore, verify that it is installed before you begin the tutorials.
To see if Sample Application is installed:
Log in to the Workspace home page using your Workspace username and password.
Click the down arrow on the right side of the Application Builder icon.
From the menu, select Demonstrations.
The Demonstration Applications page appears, displaying links to demonstration applications.
Locate Sample Application and check the Status column:
If the Status column displays Installed, then return to the Workspace home page.
If the Status column displays Not Installed, then select Install in the Action column. Follow the on-screen instructions.