Oracle Web Application Programming for PL/SQL Developers
Susan Boardman
Melanie Caffrey
Solomon Morse
Benjamin Rosenzweig

ISBN-10: 0130477311
ISBN-13: 9780130477316

Publisher: Prentice Hall
Copyright: 2003
Format: Paper; 745 pp
Published: 12/18/2002

Suggested retail price: $44.99
Buy from myPearsonStore



Appropriate for courses in Oracle.

This comprehensive tutorial immerses students hands-on in using Oracle PL/SQL and the Oracle Internet Application Server to generate dynamic front-end web pages that access an Oracle Database. They learn step-by-step how to create and deploy Web applications using PL/SQL, HTMEL, Java, XMIL, WML, Perl and PHP.

  • Core topics—Provides important information on HTML, Java, XML, WML, Perl and PBP.

    • Brings students up to speed quickly in the basics so they can use various techniques intelligently, rather than mechanically, to produce superior results.

  • Various maintenance duties—e.g., troubleshooting, debugging, indexing, testing, and site analysis.

    • Gives students hands-on practice in thinking and working like professionals, rather than just programmers in training.

  • Packed with practical tips.

    • Saves students time, effort, and frustration while developing and deploying Internet-ready, e-commerce applications using Oracle 9i.



Acknowledgments.


About the Authors.


Foreword.


Preface.

I. INTRODUCTION.

1. Introduction to Oracle Web Applications.

Internet and Web Basics. What Are Web Applications?

2. Oracle 9iA.

Oracle 9iAS Architecture. Oracle 9iAS Configuration.

3. Remote Server Access.

Working with the Server.

4. Web Application Design.

What Is Web Design? How to Design a Web Application. Tips for Web Design.

II. CREATING THE APPLICATION.

5. Introduction to HTML: Basic Tags, Tables, and Frames.

Basic HTML Concepts. Common HTML Tags. Basic Tables. Basic Frames.

6. Advanced HTML: Forms, Nested Tables, and Nested Frames.

An Introduction to Forms. Advanced Tables. Advanced Framesets.

7. Introduction to JavaScript.

Embedding JavaScript in HTML. JavaScript Syntax. The Document Object Model. JavaScript Events. Window and Document Objects.

8. SQL Reminders and Tips.

SQL Basics. Advanced Uses of SQL's NVL and DECODE Functions.

9. PL/SQL Review.

Basic Concepts of PL/SQL. Stored Procedures. Packages. PL/SQL Tables.

10. Web Toolkit I: HTML and JavaScript with PL/SQL.

Web-Enable Databases. Create Web Pages in PL/SQL.

11. Web Toolkit II: Frames, Forms, and Parameters.

Frames. Forms and Form Handlers. Passing Parameters without Submitting Forms.

12. Working with PL/SQL Server Pages (PSPs).

What PL/SQL Server Pages Are. When to Use PSPs. Loading PSPs into the Database. Developing PSPs.

13. Images.

Image Types. Storing and Retrieving Images in the Database. JavaScript and Images. Image Maps.

14. JavaScript Form Validation.

Form Validation Using JavaScript. Regular Expressions in Form Validation.

15. Maintaining State with Cookies and Tables.

Using Cookies to Maintain State. The Web Toolkit and Cookies. JavaScript and Cookies. Storing State in Database Tables.

III. TAPAS.

16. The owa_util Package: Dynamic SQL, HTML, Date Utilities, and More.

Dynamic SQL Utilities. HTML Utilities. Date Utilities. Miscellaneous Utilities.

17. Troubleshooting.

Use Good Coding and Debugging Practices. Distinguish Error Messages. Find and Debug PL/SQL Errors. Find and Debug JavaScript Errors. Find and Debug HTML Errors.

18. Web Tips and Techniques.

Add Functionality to Forms. Use Stylesheets. Store Images for Performance. Use Dynamic SQL. Write and Reuse Modular Components.

19. Additional Web Toolkit Utilities and PL/SQL Built-ins.

Sending Electronic Mail from an Oracle Database. Reading Other Web Sites. Encrypting Sensitive Data. Security and Authentication. Read-Consistent Updates. Searching and Replacing Text.

20. Web Application Architecture.

Designing Code Structures. Designing for Performance. Overview of Architecture Considerations.

Appendix A. Student Database Schema.

Appendix B. PL/SQL Formatting Guide.

Appendix C. HTML Formatting Guide.

Index.

SUSAN BOARDMAN, Lead Software Engineer for IntraSphere Technologies, specializes in using PL/SQL to build intranet Web applications. She has extensive experience with retail systems, back-end processing, and university applications.

SOLOMON MORSE, Senior Consultant for Net Quotient Consulting Group in New York City, specializes in designing and developing database-integrated e-business Web applications. He has developed Web applications for cutting-edge e-journals as well as for Fortune 500 companies.

MELANIE CAFFREY is an Oracle consultant in New York City, providing front-end and back-end Oracle solutions to numerous clients. She is co-author of the Oracle DBA Interactive Workbook and Oracle Database Administration: The Complete Video Course.

BENJAMIN ROSENZWEIG is an Integration Specialist at IQ Financial Systems. Prior to that he was a principal consultant for 3 1/2 years at Oracle Corporation in the Custom Development Department. He has a wide range of computer experience from creating an electronic Tibetan-English Dictionary in Kathmandu, Nepal, to supporting presentations centers at Goldman Sachs and managing a trading system at TIAA-CREF.

The authors are all members of the faculty at Columbia University School of Continuing Education.

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!

View a Sample Chapter PDF: /samplechapter/0130477311.pdf

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, contact your Pearson Higher Education representative for pricing and ordering information.

This title is a member of the Prentice Hall PTR Oracle Series, which also contains the titles below . You can also visit the Prentice Hall PTR Oracle Series page.

  • 013140301XOracle DBA Automation Quick Reference
    Russel & Cordingley
    © 2004 | Prentice Hall | Paper; 320 pages | Instock
    ISBN-10: 013140301X | ISBN-13: 9780131403017
    Buy from myPearsonStore

    • This book gives the reader best practices for implementing and managing a datawarehouse on the Oracle Platform. This book tells datawarehousing professionals what they need to totally change the way they manage databases and to use star schemas to run an efficient datawarehouse.

  • 0130325848Oracle DBA Guide to Data Warehousing and Star Schemas
    Scalzo
    © 2003 | Prentice Hall | Paper; 240 pages | Instock
    ISBN-10: 0130325848 | ISBN-13: 9780130325846
    Brief Description | Buy from myPearsonStore

  • 0137144229Oracle PL/SQL by Example, 4/E
    Rosenzweig & Rakhimov
    © 2009 | Prentice Hall | Paper; 768 pages | Instock
    ISBN-10: 0137144229 | ISBN-13: 9780137144228
    Buy from myPearsonStore

    • Learn PL/SQL through a proven hands-on tutorial, with practical exercises,

    poignant self-review questions, and real-world answers. This book teaches all

    the Oracle PL/SQL skills you need, through hands-on, real-world labs,

    exercises, projects, and our great Web-based training site! Coverage includes

    every key Oracle PL/SQL concept, including: the basics of structured

    programming; PL/SQL structure and syntax; iterative control; scoping and

    anchored datatypes; SQL within PL/SQL; for update cursors and

    subprograms; stored code, triggers, security, tables, even advanced-level

    package and parameter passing techniques. A free Web-based training module

    includes a Virtual Study Lounge where readers can interact with the author.

    As Oracle's premier tool for building store procedures, PL/SQL uniquely

    supplements the standard relational database language, SQL, with the features

    needed to build real-world applications.

    Oracle Developers typically learn SQL before venturing in to Oracle's

    PL/SQL. SQL is the foundation Language on which PL/SQL is build.

  • 0131172611Oracle PL/SQL by Example, 3/E
    Rosenzweig & Silvestrova
    © 2004 | Prentice Hall | Paper; 768 pages | Instock
    ISBN-10: 0131172611 | ISBN-13: 9780131172616
    Brief Description | Buy from myPearsonStore

  • 0201634457Oracle PL/SQL by Example
    Anderson & Wendelken
    © 1997 | Addison-Wesley Professional | Paper; 624 pages | Estimated Availability: 11/13/1996
    ISBN-10: 0201634457 | ISBN-13: 9780201634457
    Buy from myPearsonStore

  • 0137151683Oracle PL/SQL by Example, Safari, 4/E
    Rosenzweig & Rakhimov
    © 2009 | Prentice Hall | On-line Supplement; 768 pages | Instock
    ISBN-10: 0137151683 | ISBN-13: 9780137151684
    URL: http://safari.informit.com


    • Optimizing SQL code is the #1 factor in improving Oracle database performance, yet most guides to Oracle tuning virtually ignore SQL. Oracle SQL High Performance Tuning, Second Edition, zeroes in on SQL, showing how to achieve performance gains of developers and DBA's single source for guidance on every aspect of Oracle 8i SQL and PL/SQL tuning. The book outlines up-front design techniques for enhancing application efficiency; includes detailed real-world tuning guidelines for both SQL and PL/SQL; and presents opportunities to improve performance by substituting PL/SQL or Java for SQL.

  • 0130123811Oracle SQL High-Performance Tuning, 2/E
    Harrison
    © 2001 | Prentice Hall | Paper; 656 pages | Instock
    ISBN-10: 0130123811 | ISBN-13: 9780130123817
    Brief Description | Buy from myPearsonStore

    • Oracle SQL by Example, Third Edition is a convenient, quick way to master

    Oracle SQL. This unique integrated book-and-Web learning solution teaches all

    the SQL skills you will need to succeed in an Oracle environment. Through

    hands-on, real-world labs, exercises, projects, and a superb Web-based training

    site, the book teaches administrators and programemrs alike the core skills

    required for their jobs. Coverage includes every key Oracle SQL concept,

    including: entity-relationship diagrams, the SQL*Plus environment, SELECT

    and other statements, Boolean operations, joins, aggregate and not-aggregate

    functions. Each chapter contains review exercises that help the reader master

    the important skills before they move on.

  • 0131451316Oracle SQL by Example, 3/E
    Rischert
    © 2004 | Prentice Hall | Paper; 960 pages | Instock
    ISBN-10: 0131451316 | ISBN-13: 9780131451315
    Brief Description | Buy from myPearsonStore

    • Appropriate for courses in Oracle.

    This comprehensive tutorial immerses students hands-on in using Oracle PL/SQL and the Oracle Internet Application Server to generate dynamic front-end web pages that access an Oracle Database. They learn step-by-step how to create and deploy Web applications using PL/SQL, HTMEL, Java, XMIL, WML, Perl and PHP.

  • 0130477311Oracle Web Application Programming for PL/SQL Developers
    Boardman, Caffrey, Morse & Rosenzweig
    © 2003 | Prentice Hall | Paper; 745 pages | Instock
    ISBN-10: 0130477311 | ISBN-13: 9780130477316
    Brief Description | Buy from myPearsonStore

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.


Copyright ©2009 Pearson Education. All rights reserved. Legal Notice | Privacy Policy | Permissions