Easy HTML-DB Oracle Application Express: Create Dynamic Web Pages with OAE

Description

Oracle Application Express (formerly called HTML DB) is one of the most exciting web application development tools on the market and this is the first and best HTML-DB Application express book. HTML-DB Application Express is a true Rapid Application Development environment that can take an idea from concept to a working production level application in a very short period of time and this book can help.

This unique book provides easy step-by-step examples to guide you through the various features and removes the guesswork from learning Oracle HTML DB Application Express. This book describes the techniques necessary to build Easy HTML DB Application Express applications, and shows working examples of HTML DB database access from the simple web page population to the complex database transaction enforcing multi-user concurrency.

This book is unique because it describes all HTML DB Application Express concepts in an easy to understand language and contains step-by-step working examples of various HTML DB features. The HTML-DB Application Express book shows the when, where, why, and how of using each feature to build and deploy your web applications. It is designed for any Oracle professional including DBA's, application developers, Network Engineers and IT managers.

 

Table of Contents

Section I - Introduction, Installation, and Configuration
The components that make up the HTML DB development environment.

CHAPTER 1 - Installing Oracle HTTP Server

CHAPTER 2 - Installing HTML DB

Installation of HTML DB version 1.6
Upgrading to HTML DB version 1.6.1

CHAPTER 3 - HTML DB Basic Administration I

Just the basics - a brief demonstration of getting started with HTML DB. More in depth information will be provided in a later chapter.

Creating a workspace in manual mode, simple, just enough to continue with examples in the book

Section II - Getting to Know HTML DB

CHAPTER 4 - Oracle HTML-DB Data Workshop

Importing Data
Exporting Data

CHAPTER 5 - HTML-DB SQL Workshop

SQL Command Processor
UI Defaults
Explain Plan
Browsing Database Objects
Query by example
Scripts

CHAPTER 6 - Learning the HTML DB Application Builder

Application Attributes
Pages
     Regions
     Page Rendering
     Regions
     Buttons
     Items
     Computations
     Processes
Page Processing
     Computations
     Validations
     Processes
     Conditional Processing
     Branches
Shared Components
     Application Level Items
     Tabs
     List of Values (LOV)
     Menus
     Lists
     Theme
     Templates
     Security
     Navigation Bar
 Wizards
Utilities
CSS and Image Files
Export/Import

Section III - Building Applications
CHAPTER 7 - Creating Web Pages with HTML DB
Forms
Reports
Charts
Buttons
Items
List of Values (LOVs)
Calendars
Shortcuts
Java

CHAPTER 8 - Navigation

Buttons
Tabs
NavBar
Breadcrumb Menus
Trees

Section IV - Advanced

CHAPTER 9 - Customizing HTML DB

 Java Script
 Themes
      Copy, Customize
 CSS
 Templates
      Copy, Modify
      Substitution Strings

CHAPTER 9- Application Deployment with Oracle HTML-DB

Loading pictures and images
Deploying your app to production
Using Application Builder Utilities to Deploy Your App
Export/Import
CSS and Image Files
The Export Repository

CHAPTER 10- HTML DB Administration II

Administration Home
Service Administration
Manage Engine Settings
Workspace Provisioning
Managing Requests
Managing Workspaces
Export
Import
Managing Users
Security


CHAPTER 11 - Tips and Tricks


CHAPTER 12 - Debugging

CHAPTER 13 - HTML DB API’s

CHAPTER 14 - Best Practices

Appendix

Glossary

Index