Skip Headers
Oracle® Database Express Edition 2 Day Plus Application Express Developer Guide
Release 2.1
Part Number B25310-01
Home
Book List
Master Index
Contact Us
Next
View PDF
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
How to Create a Tabular Form
About the HR Account
Unlocking the HR Account
Logging in to the HR User Account
Creating an Application
Creating a Tabular Form Using a Wizard
Changing the Department Id Column to a Select List
2
How to Create a Parameterized Report
Sample Report Utilizing a Form Input
About Sample Application
Creating a New Page
Creating the Query Region
Adding an Item
Adding a Button to Submit the Page
Run the Page
3
How to Create a Drill Down Report
About Sample Application
Creating a New Application
Creating Reports for DEMO_ORDERS and DEMO_ORDER_ITEMS
Create a Report for DEMO_ORDERS
Create a Report for DEMO_ORDER_ITEMS
Customizing the DEMO_ORDER_ITEMS Report
Add an Item to Hold the Value of ORDER_ID
Add a Condition
Modify the Region Title
Linking the DEMO_ORDERS Report to the DEMO_ORDER_ITEMS Report
4
How to Control Form Layout
About Sample Application
Creating a Table and Data Input Form
Create the HT_EMP Table
Create a New Page Containing a Input Form
Run the Page
Changing the Appearance of a Page by Altering Region Attributes
Understanding How Item Attributes Effect Page Layout
Edit Item Attributes
Fix Item Alignment
Change Items to Display-only
Adding a Region Header and Footer
Making a Region Conditional
Adding Another Region for HTML Text
Changing Item Types
Change an Item to a Radio Group
Change an Item to a Select List
Change an Item to a Check Box
About Label Templates
Changing Buttons
Running the Page for Update
Making Data Bold
5
How to Work with Check Boxes
About Sample Application
Creating a Single Value Check Box on a Form
Change Product Available Radio Group to a Check Box
Alter the Check Box Position
Change Default Check Box Behavior
Creating Multi Value Check Box to Filter Content
Create a Multi Value Check Box
Alter Check Box Display Values
Change Where the Check Boxes Display
Create a Go Button to Submit the Page
Adjust Default Check Box Behavior
Adding Check Boxes to Each Row in the Report
Call HTMLDB_ITEM.CHECKBOX
Add a Button to Submit Check Box Array Values
Add a Process
6
How to Implement a Web Service
About Creating Web Service References
Creating a New Application
Specifying an Application Proxy Server Address
Searching a UDDI Registry for a Business Name
Create a Form to Display a Stock Quote
Searching a UDDI Registry for a Service Name
Create a Form and Report
7
How to Create a Stacked Bar Chart
About Sample Application
Creating a Stacked Bar Chart
Adding Additional Series
Changing the Chart Format
Viewing the Chart
8
How to Upload and Download Files in an Application
Creating an Application
Creating an Upload Form
Create an HTML Region
Create an Upload Item
Create a Button
Creating a Report with Download Links
Create a Report on HTMLDB_APPLICATION_FILES
Add Link to Download Documents
Storing Additional Attributes About the Document
Create a Table to Store Document Attributes
Create an Item to Capture the Document Subject
Create a Process to Insert Information
Showing Additional Attributes in the Report Region
Store the Document in a Custom Table
Downloading Documents from the Custom Table
9
How to Incorporate JavaScript into an Application
Understanding How to Incorporate JavaScript Functions
Incorporating JavaScript in the HTML Header Attribute
Including JavaScript in a .js File Referenced by the Page Template
About Referencing Items Using JavaScript
Calling JavaScript from a Button
Creating a Client Side JavaScript Validation
About Accessing the HR Account
Create an Application on the EMPLOYEES Table
Add a Function to the HTML Header Attribute
Edit an Item to Call the Function
Enabling and Disabling Form Elements
Add a Function the HTML Header Attribute
Edit an Item to Call the Function
Change P2_DEPARTMENT_ID to a Select List
Create a Call to the disFormItems Function
Changing the Value of Form Elements
10
How to Build and Deploy an Issue Tracking Application
Planning and Project Analysis
Planning and Project Analysis
Designing the Database Objects
About the Projects Table
About the People Table
About the Issues Table
Implementing Database Objects
Build the Database Objects
View the Created Database Objects
Loading Demonstration Data
Load Projects Data
Load People Data
Load Issues Data
Building a Basic User Interface
Create the Application
Add Pages to Maintain Projects
Add Pages to Track People
Add Pages to Track Issues
Create Summary Reports
Add Content to the Home Page
Add a Breadcrumb Menu
Adding Advanced Features
Add Support for Email Notification
Add Application Security
Deploying Your Application
Move the Application Definition
Alternate Authentication Mechanisms to Consider
Create Users
Publish the URL
A
DDLs and Scripts for Issue Tracking Application
Create Application Database Objects DDL
Create Issues Script