Course Contents
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 11g 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.
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