You are previewing Oracle® Web Application Programming for PL/SQL® Developers.
O'Reilly logo
Oracle® Web Application Programming for PL/SQL® Developers

Book Description

The hands-on, rapid-mastery guide to Oracle PL/SQL Web development.

  • Start building Oracle 9i PL/SQL Web applications—hands on

  • Covers the entire development lifecycle, from design to deployment

  • Provides instruction for PL/SQL Server Pages, the PL/SQL Web Toolkit, and the Oracle 9i Application Server

  • Introduces Web basics—HTML, JavaScript, basic UNIX and FTP, and image handling

  • Reviews PL/SQL and SQL concepts

  • Includes practical tips and troubleshooting help

  • Leverage your SQL and PL/SQL experience to build powerful data-driven Web and e-business applications—starting right now! In this book, a team of Columbia University PL/SQL instructors cover the core pieces of what you need to know, from preliminary configuration to deployment of dynamic, data-driven applications. You'll find practical examples, hands-on exercises, and dozens of practical tips and solutions designed to save you time, effort, and frustration. One step at a time, discover how to:

  • Configure Oracle's Internet Application Server

  • Control Web applications and servers remotely

  • Build Oracle Web applications with PL/SQL

  • Create dynamic, data-driven pages

  • Test, debug, troubleshoot, and deploy your applications

  • Maintain and optimize running Web applications

  • Whether you've been writing simple queries or complex PL/SQL code, this book takes your database development skills onto the Web—and into the future!

    Table of Contents

    1. Copyright
    2. The Prentice Hall PTR Oracle SeriesThe Independent Voice on Oracle
    3. About Prentice Hall Professional Technical Reference
    4. Acknowledgments
    5. About the Authors
    6. Foreword
    7. Preface
    8. Introduction
      1. Introduction to Oracle Web Applications
        1. Internet and Web Basics
        2. What are Web Applications?
      2. Oracle 9iAS
        1. Oracle 9iAS Architecture
        2. Oracle 9iAS Configuration
      3. Remote Server Access
        1. Working with the Server
      4. Web Application Design
        1. What is Web Design?
        2. How to Design a Web Application
        3. Tips for Web Design
    9. Creating the Application
      1. Introduction to HTML: Basic Tags, Tables, and Frames
        1. Basic HTML Concepts
        2. Common HTML Tags
        3. Basic Tables
        4. Basic Frames
        5. Chapter 5: Building the APP
      2. Advanced HTML: Forms, Nested Tables, and Nested Frames
        1. An Introduction to Forms
        2. Advanced Tables
        3. Advanced Framesets
        4. Chapter 6: Building the APP
      3. Introduction To JavaScript
        1. Embedding JavaScript in HTML
        2. JavaScript Syntax
        3. The Document Object Model
        4. JavaScript Events
        5. Window and Document Objects
        6. Chapter 7: Building the APP
      4. SQL Reminders and Tips
        1. SQL Basics
        2. Advanced Uses of SQL’S NVL and DECODE Functions
        3. Chapter 8: Building the APP
      5. PL/SQL Review
        1. Basic Concepts of PL/SQL
        2. Stored Procedures
        3. Packages
        4. PL/SQL Tables
        5. Chapter 9: Building the APP
      6. Web Toolkit I: HTML And JavaScript With PL/SQL
        1. Web-Enable Databases
        2. Create Web Pages in PL/SQL
        3. Chapter 10: Building the APP
      7. Web Toolkit II: Frames, Forms, and Parameters
        1. Frames
        2. Forms and Form Handlers
        3. Passing Parameters without Submitting Forms
        4. Chapter 11: Building the APP
      8. Working with PL/SQL Server Pages (PSPs)
        1. What PL/SQL Server Pages Are
        2. When to Use PSPs
        3. Loading PSPs into the Database
        4. Developing PSPs
        5. Chapter 12: Building the APP
      9. Images
        1. Image Types
        2. Storing and Retrieving Images in the Database
        3. JavaScript and Images
        4. Image Maps
        5. Chapter 13: Building the APP
      10. JavaScript Form Validation
        1. Form Validation Using JavaScript
        2. Regular Expressions in Form Validation
        3. Chapter 14: Building the APP
      11. Maintaining State with Cookies and Tables
        1. Using Cookies to Maintain State
        2. The Web Toolkit and Cookies
        3. JavaScript and Cookies
        4. Storing State in Database Tables
    10. Tapas
      1. The OWA_UTIL Package: Dynamic SQL, HTML, Date Utilities, and More
        1. Dynamic SQL Utilities
        2. HTML Utilities
        3. Date Utilities
        4. Miscellaneous Utilities
        5. Chapter 16: Building the APP
      2. Troubleshooting
        1. Use Good Coding and Debugging Practices
        2. Distinguish Error Messages
        3. Find and Debug PL/SQL Errors
        4. Find and Debug JavaScript Errors
        5. Find and Debug HTML Errors
      3. Web Tips and Techniques
        1. Add Functionality to Forms
        2. Use Stylesheets
        3. Store Images for Performance
        4. Use Dynamic SQL
        5. Write and Reuse Modular Components
      4. Additional Web Toolkit Utilities and PL/SQL Built-ins
        1. Sending Electronic Mail From an Oracle Database
        2. Reading Other Web Sites
        3. Encrypting Sensitive Data
        4. Security and Authentication
        5. Read-Consistent Updates
        6. Searching and Replacing Text
      5. Web Application Architecture
        1. Designing Code Structures
        2. Designing for Performance
        3. Overview of Architecture Considerations
    11. Student Database Schema
      1. Table And Column Descriptions
    12. PL/SQL Formatting Guide
      1. PL/SQL Code Naming Conventions and Formatting Guidelines
      2. Other Suggestions
    13. HTML Formatting Guide
      1. HTML Code Naming Conventions and Formatting Guidelines