Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 About these Tutorials

• What this Book Is Not
• Tutorial Topics
• Installing the HR Database Objects
• Checking the Sample Application Installation

2 How to Create a Tabular Form

• Creating an Application
• Creating a Tabular Form Using a Wizard
• Changing the Department Id Column to a Select List

3 How to Create a Parameterized Report

• Sample Report Utilizing a Form Input
• Creating a New Page
• Creating the Query Region
• Adding an Item
• Adding a Button to Submit the Page
  • Run the Page

4 How to Create a Drill Down Report

• 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

5 How to Control Form Layout

• Creating a Table and Data Input Form
  • Create the HT_EMP Table
  • Create a New Page Containing an Input Form
  • Run the Page
• Changing the Appearance of a Page by Altering Region Attributes
• Understanding How Item Attributes Affect 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

6 How to Work with Check Boxes

• Creating a Single Value Check Box on a Form
  • Change Product Available Radio Group to a Check Box
  • Change the Check Box Position
  • Change Default Check Box Behavior
• Creating Multi Value Check Box to Filter Content
  • Create a Multi Value Check Box
  • Change Check Box Display Values
  • Change Where the Check Boxes Display
  • Create a Go Button to Submit the Page
  • Change the Default Check Box Behavior
• Adding Check Boxes to Each Row in the Report
  • Call APEX_ITEM.CHECKBOX
  • Add a Button to Submit Check Box Array Values
  • Add a Process

7 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
  • Create a Form and Report

8 How to Create a Stacked Bar Chart

• Creating a Stacked Bar Chart
• Adding Additional Series
• Changing the Chart Format
• Viewing the Chart

9 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 APEX_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
  • Show Additional Attributes in the Report Region
• Storing the Document in a Custom Table
• Downloading Documents from the Custom Table
• Security Issues to Consider

10 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
  • 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 to 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

11 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

• Creating Application Database Objects DDL
• Creating Issues Script