PREREQUISITES:   Familarity with Oracle and basic programming experience is assumed. DURATION:   3 days. Hands on. OBJECTIVES:   Oracle Application Express (formerly HTML DB) is a Web-based application development tool integrated with Oracle9i Database Release 2 and all releases of Oracle Database 10g. It enables anyone with limited programming experience and a Web browser to rapidly develop scalable Web applications that can be quickly deployed to tens, hundreds or thousands of users. Upon completion of this course, participants will be able to: * Describe components of Oracle’s Application Express * Retrieve data & create reports from an Oracle database using Application Express * Create web page applications Application Express COURSE CONTENT:   Introduction to Application Express Overview of the SQL Workshop Using Object Browser Managing the User Interface SQL Command Processor Data Import & Export Overview of the Application Builder Adding Pages Tab Styles Application Attributes Application Themes & Templates Template Types Managing Templates Substitution Variables Header, Body and Footer Definitions Building a Web Page in Application Express Adding, Deleting and Editing Pages Adding Help Messages to a Page Page Regions and Advanced Concepts Describing Session State Management Discussing the use of Page & Application Variables Debugging Techniques for Page & Application Variables Advanced Reporting Techniques Defining and Processing Forms Items Lists Buttons Branches Navigating Between Pages (CH11) Understanding f?p syntax URL Tabs Breadcrumb Menus Lists Trees Other Components (CH12) List of Values (LOV) Graphs Calendar Computations, Processes and Validations (CH13) Validations Computations Processes