ISBN: 0-9761573-1-4 ISBN 13 978-0976157311 Library of Congress Number: 2005928016 400 pages  Perfect bind - 9x7   Shelving:  Databases/Oracle Easy Oracle Series # 3   Easy HTML-DB Oracle Application Express Create Dynamic Web Pages with Apex Michael Cunningham & Kent Crotty Retail Price $39.95 /  £29.95 Order now and get online access to the code depot! Only $27.95 (30% off)         Key Features   About the Authors Table of Contents Index   Reader Comments Errata         Get the Oracle Developer Pack Six for $79.95 - A $145.00 value Easy Oracle Application Express (HTML-DB) $39.95 Oracle 10g Reference Poster $8.95 Oracle Backup & Recovery Scripts download $16.95 Oracle PHP: Create web pages with Oracle $27.95 Oracle PL/SQL Programming $16.95 Oracle PL/SQL Tuning $34.95 Oracle Application Express (Apex, 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 Apex 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.     * See ready-to-use examples for creating HTML-DB applications * Learn step-by-step examples of HTML-DB data access and document formatting * Create dynamic web content with HTML-DB Application Express * See real-world techniques for managing Oracle HTML with DTD definitions * Understand how to update Oracle HTML-DB Application Express * Learn the best practices for developing HTML-DB Application Express (Apex) systems to improve productivity, performance, and security * Learn how to customize your application with Themes and CSS * Learn how to package your HTML-DB Apex system for easy deployment. * See Rapid Application Development techniques to create Oracle applications, fast About the Authors: Kent Crotty   Kent Crotty is Oracle Certified DBA and a graduate of the University of Maryland.  He is an IT professional with over 15 years in a variety of roles ranging from Programmer/Analyst (developer) to Systems and Database Administrator.  Kent is instrumental in developing complex Oracle systems architectures and specializes on web-based Oracle applications.  Kent is a well-rounded Oracle DBA with a broad range of experience and skills.         Michael Cunningham Michael Cunningham has been a Software Engineer and DBA working with Oracle for over 11 years. He has worked as technical consultant on applications ranging from Insurance to Biological/Chemical Analysis. Michael currently works as a DBA for an Insurance company in Northern California. Michael lives in the Napa Valley with his wife and two daughters and they love to travel around the country in their motor home – and drink wine, of course.   Using the Online Code Depot Conventions Used in this Book Acknowledgments Preface Chapter 1:  General Installation and Configuration Introduction to the Basics Oracle HTTP Server What is Oracle HTTP Server? Prior to Installation Installing Oracle HTTP Server Testing the Oracle HTTP Server Installation Post Installation Stopping and Restarting the Oracle HTTP Server About OPMN Conclusion Chapter 2:  Installation and Configuration of HTML DB Preparing for Installation of HTML DB Create the HTMLDB20 Tablespace Create the HTML DB Database Objects Installing the HTML DB Images Database Access Descripton Encrypting the dads.conf Passwords Testing Oracle HTML DB Troubleshooting Problems with HTML DB Connections Service Temporarily Unavailable The Page Cannot Be Found No Images Show on the Screen Forbidden File Upload Problems Conclusion Chapter 3:  HTML DB Administration Creating a Workspace Using the Manual Method Creating a New User Conclusion Chapter 4:  Hello World Introduction Building the Application Exploring the Conference RSVP Application Conclusion Chapter 5:  HTML DB SQL Workshop Introduction The SQL Workshop Interface Object Browser Query Builder SQL Command Processor Explain Plan SQL Scripts Utilities Data Import/Export Object Reports Database Monitor Recycle Bin SQL Workshop: Data Import/Export Importing Text Data XML Import Import Spreadsheet Data Export Text Data XML Export Import Repository Import Exercise Conclusion Chapter 6:  Learning the HTML DB Application Builder Introduction Editing an Application Run Application Edit Attributes Shared Components Export/Import Tasks Standard Attributes Name Application Alias Version Image Prefix Logging Parsing Schema Status Build Status Global Notification Substitutions Logo Security Attributes Home Link Public User Authorization Scheme Parsing Schema Session State Protection Virtual Private Database (VPD) Application Pages Page Definition Regions Page Events View Page Objects View Page History View Page Export View Page Groups View Page References View Page Rendering Page Level Computations Page Level Processes Session State Reference Types for Page Items Preferences HTML DB URL Format Shared Components Logic:  Application Level Components Security Navigation User Interface Lists of Values (LOV) Shortcuts Files Export/Import Developer Toolbar Page Zero Creating a Page Zero Easy HTML DB Book application Conclusion Chapter 7:  Creating Reports Introduction Building a Report Using the Report Wizard Add Query By Example to a Report Using HTML Expressions Report Attributes Column Attributes Layout and Pagination Sorting Messages Report Export Break Formatting Column Attributes Column Definition Column Formatting Tabular Form Element List of Values Formatting Numeric and Date Columns Conclusion Chapter 8:  Creating Forms Building a Form Using the Form Wizards Examining the Results of the Form Wizard Examining Buttons Examining Automatic Row Fetch Examining Automatic Row Processing (DML) Special Note About REQUEST and Database Action Adding a Page Item to a Form Controlling Form Layout Building Tabular Forms Examining the Results of the Tabular Form Wizard Examining Tabular Form Buttons Examining the Multi Row Processes Add Rows to a Tabular Form Process Adding a Column to a Tabular Form Creating a Form on a Table with Report Creating a Master Detail Form Creating a Form for Email Conclusion Chapter 9:  Working with Images and Documents Storing Files in HTML DB Explaining WWV_FLOW_FILES Loading and Displaying Images Create the EASY_IMAGE Table Creating the Image Upload Application Page Create the File Browse… Item Create the Upload Button Create the Copy Image Process Creating the PL/SQL Procedure to Display the Image Creating the Display Image Application Page Using HTML Expression to Display an Image Uploading and Downloading Documents Create the Document Upload Page Creating a Report to Display the Documents Downloading a PDF into the Browser Conclusion Chapter 10:  Creating Other Components in HTML DB Checkboxes Working with Checkbox Data Format of Data in Relation to Checkboxes Working with Checkboxes in Reports and Tabular Forms Buttons Create a Button in a Region Position Create a Button Displayed Among This Region’s Items Button Attributes Creating Multiple Buttons Date Picker PICK_DATE_FORMAT_MASK SINCE Lists of Values Static LOV Dynamic LOV Publish and Subscribe Select Lists Parent Child Select Lists Multiple Select Lists Working with Multiple Select Lists List Manager Working with List Manager Items Radio Buttons Collections Working with Collections Charts Creating a Page with a Chart Creating a SVG Chart Calendars Creating a Calendar Customizing a Calendar Stop and Start Table Text Fields Text Field Attributes Text Area Fields Display Only Fields Hidden Fields Password Fields Conclusion Chapter 11:  Navigation in HTML DB Lists and DHTML Lists Creating a List Creating a List Region DHTML Lists Breadcrumbs Creating a Breadcrumb Menu Creating a Breadcrumb Region Navigation Bar Creating a Navigation Bar Navigation Bars and Images in the Page Templates Trees Creating a Tree Creating Trees on Application Pages Tabs Standard Tabs Editing Tabs Adding Tabs to a Page Parent Tabs Conclusion Chapter 12:  Page Processing Introduction Logic Controls Computations Computation Locations Computation Points Computation Types Creating Computations Validations Validation Levels Validation Methods Error Messages Display Location Creating Validations Processes Process Types Process Points Creating Processes Branching Branching Points Branch Type Creating a Branch Computation and Processing Points in Detail Page Processing Events Conclusion Chapter 13:  Customizing HTML DB Introduction Themes Changing the Theme for an Application Default Templates for a Theme JavaScript JavaScript Source Code Cascading Style Sheets Internal CSS External CSS Inline CSS HTML DB Cascading Style Sheets Overriding Properties Defined in the HTML DB Style Sheets Creating and Adding Your Own CSS Templates Creating a Region Template Creating a Page Template Using the Templates You Have Created Conclusion Chapter 14:  Application Deployment with HTMLDB Introduction Development Server Production Server Generating the DDL for the Application Exporting the DDL Script File Exporting Data Exporting the Application Exporting Cascading Style Sheets Exporting Images Exporting Static Files User Interface Defaults Importing and Running the DDL script Importing the Application Importing a Cascading Style Sheet Importing a Static File (JavaScript) Exporting Themes Importing a Theme Conclusion Chapter 15:  HTMLDB Administration II Administering the Development Environment Manage Service Environment Settings Site Specific Tasks Managing Service and Change Requests Managing HTML DB Logs Managing Session State Managing the Mail Queue Managing Workspaces Creating a Workspace Existing Workspaces Removing a Workspace Manage Workspace to Schema Assignments Managing the Developers and Users Exporting a Workspace Importing a Workspace Manage Applications Application Attributes Build Status Conclusion Chapter 16:  Best Practices and Techniques Publish and Subscribe Publishing Refreshing the Subscriber Creative use of Substitution Strings Performance Considerations Page Zero User Interface Defaults Opening Multiple Browsers for Development Using APP_ID and APP_PAGE_ID Application Page Reuse Step 1: Setup the Re-usable Application Page Step 2: Setup the Calling Application Step 3: Setup the Calling Application Page Setting the Sizes of Page Components Regions Select Lists Tabular Form Field Viewing the HTLM DB Source Code Learning from the HTML DB Applications Conclusion Chapter 17:  Debugging Displaying Debug Information Troubleshooting a Performance Problem Troubleshooting SQL Errors More About Troubleshooting Isolating the Region with the Error SQL Trace WWV_FLOW.DEBUG WWV_FLOW.SHOW_ERROR_MESSAGE Conclusion Chapter 18:  HTML DB API HTMLDB_UTIL HTMLDB_CUSTOM_AUTH HTMLDB_MAIL HTMLDB_ITEM HTMLDB_APPLICATION HTMLDB_COLLECTION OWA_COOKIE OWA_UTIL Conclusion Index About Kent Crotty About Michael Cunningham Index Topics: #COLUMN_VALUE# #GLOBAL_NOTIFICATION# #IMAGE_PREFIX# #SUM_COLUMN_HEADER# A Activity Logs Add Rows to a Tabular Form Add rows to tabular form Alias Allowed Operations analysis pages Apache APP_ID APP_PAGE_ID Application Alias Application Builder Application Builder home page Application Home page Application Level Components application level processes Application Page Logging Application Page Reuse Application Status Applications Administration Exporting Importing Authorization Scheme Autocommit Automated Row Fetch Automated Row Fetch (DML) Automatic Row Fetch Automatic Row Processing Adding a Page Item to Automatic Row Processing (DML) B Best Practices Bind Variable bookmark Branches Creating Branching Branching Points Branching Types Breadcrumb Menu Creating Creating the Breadcrumb Region Break Formatting Bubble Text Build Status Button Attributes button positions Buttons Creating Multiple displayed among region items in a region position C Cache Clearing Caching Calendars creating customizing Cascading Style Sheets adding to the repository Exporting External CSS Importing included with HTLM DB Inline CSS Internal CSS ch_.sql ch_.sql ch_.sql ch_.sql ch_.sql ch_.sql ch_.sql ch_.sql ch_.txt Change Requests Managing character counter See Text Area Charts Creating SVG Checkboxes in Reports in session state clear_user_cache clearing cache Clearing Cache Collections Creating Selecting data from Working with COLSPAN Column Attributes Column Definition Column Formatting Column Link column positions Columns User Interface Defaults Companion CD Computation Type Item Value Computation Types PL/SQL Function Body SQL Expression SQL Query Static Assignment Computations After Footer After Header After Regions Before Footer Before Header Before Regions Computation Locations Computation Points Creating Error Messages Page Processing Page Rendering Concurrency Conditional Display Conference_RSVP.csv Configuration - Build Option Copy and Subscribe Copy From Application Copy Image copy_image_process.sql Create Branch Computations Validations Create an Application from a Spreadsheet Create Mode Create Processes create_checkbox_data.sql create_easy_document_table create_easy_image_table.sql Creating Workspace Creating a New Theme Creating Forms Creating Multiple Items CSS See Cascading Style Sheets CSS Class - in report columns CSS Style - in report columns CSV Output Customization Customized Option Name D DAD dads.conf Data Definition Language Data Manipulation Automated Row Fetch Data Validation Data Workshop Database Access Descriptor Database Action database dependencies for a page database design Date Picker Dates PICK_DATE_FORMAT_MASK DDL Exporting Importing death detection Debugging Displaying Debug Information Default Properties Deployment Derive Item Source Developer Toolbar DHTML Lists Templates with Images Display Null Display Only Fields Display Position DML Fetch Mode Documents downloading Uploading Documets Creating an Upload Page Download Companion CD HTML DB drill down reports Dynamic LOV E Easy HTML DB Book application Easy Samples application easy_documents_report.sql easy_products_data.sql easy_region.css easy_region_template.txt easy_report_image.sql easydev EasyHTMLDB.pdf Edit Application Attributes Edit Links Hide Show Email Configuration encryptdad.bat encryptdad.sh Encryption PlsqlDatabasePassword Error Page template Events Page Processing Explain Plan Export Text Data XML Exporting Data F F Procedure File Browse... File Upload Troubleshooting Filter Criteria FLOWS_ FLOWS_FILES Forbidden Form Layout Form on a Table or View Form on a Table with Report Form Pagination Process Type Formatting a Date column Formatting a Numeric column From source each time item is displayed G Generating DDL get_cgi_env Global Notification H Headings Type Hello World Hidden Fields Highlighting Words in a Report Home Link Hosted Oracle Site hostname htf htf.anchor HTLM DB Source Code HTML Button HTML DB Logs HTML DB API HTML DB documentation HTML DB Packages HTMLDB_APPLICATION HTMLDB_COLLECTION HTMLDB_CUSTOM_AUTH HTMLDB_ITEM HTMLDB_MAIL HTMLDB_UTIL HTML DB repository HTML Expression Displaying an Image HTML Expressions HTML Header HTML Text htmldb_..zip htmldb_admin htmldb_application htmldb_book htmldb_item.checkbox htmldb_login HTMLDB_MAIL htmldb_mail.send htmldb_mail_push_queue HTMLDB_PUBLIC_USER htmldb_util.remove_sort_preferences htmldb_util.string_to_table htmldb_util.table_to_string HTTP HTTP Server Restart Stop All I ias-component Image Files Image Prefix IMAGE_DIR Images Creating page to display Display with HTML Expression Display with PL/SQL Exporting Referencing from repository Import Repository Spreadsheet Data Text Data XML Data Import an application Import/Export Inline Error Messages insert_document_process.sql Installing HTML DB Images Oracle HTTP Server pre-installation Item Containing Primary Key Column Value Item level validation Item Not Null Validation Item on Another Page Item on This Page Item Source Item String Comparison Item Value Computation Type J JavaScript #IMAGE_PREFIX# calling from a button calling onLoad in the repository on the file system L Link Label List Manager Lists Creating Creating a List Region DHTML Lists See DHTML Lists Lists of Values Logic Controls Logo M Mail Log Mail Queue Manage Service Managing the Developers and Users Many-to-many Master Detail form Max Row Count maxlength for Tabular Form column mod_plsql Monitoring Moving a Page Item MSG_COPYRIGHT Multi Row Delete Multi Row Processes Multi Row Update Multiple Browsers Multiple Buttons Multiple Select Lists N Navigation Bar Creating displaying images in niagara_falls.jpg nobody NULLS and spaces Number of Rows (Item) O obfuscation dads.conf On Demand On New Instance OPMN opmnctl ORA- error Oracle HTTP Server Oracle Process Management Notification OracleOHS_HOMEProcessManager Output to Excel OWA_COOKIE OWA_UTIL P P procedure p_trace Page Page Definition Page Events View Page Groups Page HTML Body Attribute Page Items multiple edits Re-Sequencing Page level validation Page Locks Page Objects View Page Processing defined Events Page Rendering defined Page Zero pagination Pagination Scheme Parent Child Select Lists Parent Tabs Parsing Schema Password Fields PBL PICK_DATE_FORMAT_MASK PL/SQL Referencing session state PL/SQL Function Body Computation Type plsql_display_easy_image.sql plsql_shortcut.sql PlsqlDatabaseConnectString PlsqlDatabasePassword Encryption PlsqlDatabaseUsername PlsqlDocumentTablename Plural Name Post Element Text Preferences Primary Key Column print_cgi_env Printer Friendly Page template Process Points Application Level On Submit - After Computations and Validations On Submit - Before Computations and Validations Process Types Data Manipulation Form Pagination On Demand PL/SQL Reset Pagination Session State Processes After Footer After Header After Regions Before Footer Before Header Before Regions Processing Points Detailed Explanation Provisioning Public User Publish and Subscribe Q Query Builder Query By Example Quick Buttons R Radio Buttons Read Only Reference Types Refresh LOV Region HTML table cell attributes Region Name Region Source Region Types Regions Placement on page Regular Expression Report Attributes Report Export Report Link Report Pagination Report Wizard Reports Perfomance Conciderations Reset button Reset Preferences restartproc Restrict Access by IP Address Return Key Into Item Row Level Concurrency ROWSPAN Run and Build Application Run Application Only S schemas Schemas FLOWS_ FLOWS_FILES HTMLDB_PUBLIC_USER Script Repository Scripts Exporting Search Field Security Attributes Select Lists Returning URL redirect with Branch to Page with Redirect with Submit Service Requests Managing Session State Administration and Management Processes Set Memory Cache On Display Set Memory Cache on Fetch set_focus.txt setFocus Shared Components defined Shortcuts SINCE Singular Name Site Specific Tasks Spread Sheet SQL Expression Computation Type SQL Injection SQL Loader SQL Query Computation Type SQL Report SQL Trace SQL Workshop SQL*Plus SQLPlus Standard Attributes Standard Tabs startall startproc Static Assignment Computation Type Static Files Exporting Importing Static LOV Stop and Start Table stopall stopproc stored procedures calling with multiple parameters String Substitutions Strip HTML Substitution String Substitution Strings #IMAGE_ID# used in a Report user defined SVG Charts Switching Themes T tab set Table Properties Tablespace HTMLDB Tabs Adding to Application Pages Editing Parent Tabs Standard Tabs Tabular Form Element Tabular Forms Adding a Column to Creating Tasks Site Specific Template Based Button Template Body Template Substitution Templates Creating a Page Template Creating a Region Template Template Classes Text Area character counter Text Area Fields Text Data Import Repository Text Field (always submits) Text Fields Themes Defaul Templates Exporting Importing Switching Themes tkprof tnsnames.ora TO_CHAR TO_DATE Trace Trees Creating Creating on Application Pages Troubeshooting Troubleshooting a Performance Problem Troubleshooting SQL Errors U uppercase URL f?p= explained p?n= explained URL Arguments User Interface Defauls User Interface Defaults Exporting user_dump_dest Users Creating V Valid Request Values validateLogin Validation Levels Validation Methods Item Not Null Item String Comparison PL/SQL - Expression PL/SQL – Function Returning … Regular Expression SQL - Exists SQL - Expression SQL – Not Exists Validations Create Multiple not null validations Creating Item level validation Page level validation Version Virtual Private Database VPD W wschools Web Services Process Type When more data found message Workspace Creating Manually Workspace Management Workspace Security Workspaces Creating Exporting Importing Removing viewing Existing Workspace to Schema Assignment WWV_FLOW.DEBUG WWV_FLOW.SHOW_ERROR_MESSAGE wwv_flow_file_objects$ WWV_FLOW_FILES