Oracle 10g Application Express

Course Overview

Oracle Application Express, previously branded HTML DB, is a rapid web application development tool for the Oracle database. Using a web browser, the developer can create and deploy professional applications that are both fast and secure.

This course is designed to demonstrate the construction of Web-based applications on an Oracle 10g database, creating reports, charts, forms and menus. Attendees will learn of the capabilities within Oracle Application Express that makes development easy via pre-built templates and wizards together with its strengths and weaknesses. This third major version features some new features, notably PDF Printing and Flash charting.

Audience

• Oracle Developers / Designers
• Analyst / Programmers

Prerequisites

• HTML/Javascript Knowledge
• SQL knowledge
• View Learning Path

Course Outline

Key Features

• Reporting
• Forms
• Charting
• Spreadsheet Upload
• User Interface Themes
• Flow Control and Navigation
• Conditionality
• External Interfaces and
• Extensibility
• Security
• SQL Workshop Tools

Creating an Application

• Saving SQL for Use in Applications
• Creating a Report Drill Down Adding a Tabular Form
• Editing Application Objects
• Applying a New Theme

Build a Functional Application

• Creating a Table from a Spreadsheet
• Adding a Master Table
• Modifying a Table
• Adding a Table Using a Script
• Adding Constraints
• Adding a Master Detail Form
• Creating Lists of Values (LOVs)
• Adding an Item Validation
• Updating the Home Page Navigation List
• Adding a Logo
• Creating Users
• Restricting Access

Tabular Forms

• Changing an Updatable Column to a Select List

Parameterised Reports

• Report Utilising a Form Input
• Creating Regions
• Adding Form Items
• Adding a Button to Submit a Page
• Adding an On-load Process

Control Form Layout

• Creating a Table and Data Input Form
• Altering Region Attributes
• Adding a Region Header and Footer
• Making a Region Conditional
• Changing Item Types
• Label Templates
• Changing Buttons

Check Boxes

• Multi Value Check Boxes to Filter Content
• Adding Check Boxes in a Report

Charts

• Creating Chart Queries
• Adding Additional Series
• Editing Chart Attributes

Upload; Download Files

• Creating an Upload Form
• Creating a Report with Download Links
• Storing Additional Attributes
• Storing a Document in a Custom Table
• Downloading Documents from the Custom Table

Access Control Page

• Access Control Administration
• Creating an Access Control Administration Page
• Creating an Authentication Function
• Updating an Authentication Scheme
• Applying Authorisation Schemes to Components

Build ; Deploy an Application

• Create Summary Reports
• Breadcrumb Menus
• Email Notification
• Application Security

PDF Reports using BI Publisher

• Create a Master-detail form
• Create a report layout
• Link a PDF report to an application

Administrative Features

• Export an Application Definition
• Import an Application Definition
• Create a Workspace
• Supporting Objects