Brings students up to speed quickly in the basics so they can use various techniques intelligently, rather than mechanically, to produce superior results.
Gives students hands-on practice in thinking and working like professionals, rather than just programmers in training.
Saves students time, effort, and frustration while developing and deploying Internet-ready, e-commerce applications using Oracle 9i.
The hands-on, rapid-mastery guide to Oracle PL/SQL Web development.
Leverage your SQL and PL/SQL experience to build powerful data-driven Web and e-business applicationsstarting 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:
Whether you've been writing simple queries or complex PL/SQL code, this book takes your database development skills onto the Weband into the future!
This self-extracting zip contains the sample database files you will need to complete the exercises and labs. Take the following steps to download and extract it:
To aid your work with Oracle Web Application Programming for PL/SQL Developers, we are providing solutions for each unit of code in the sample applications to help you as you work through the book.
About the Authors.
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.
SQL Basics. Advanced Uses of SQL's NVL and DECODE Functions.9. PL/SQL Review.
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.
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.
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.
Oracle Web Application Programming for PL/SQL Developers gives PL/SQL programmers the knowledge necessary to build powerful applications on the Web.
PL/SQL, together with the Oracle Internet Application Server (iAS), provides a programmer with the ability to truly develop an entire application, from control over complex data processing on the back end, to the creation of a standardized, professional look-and-feel on the front end.
As you read and complete the exercises, you apply what you learn by building an application of your own. You create Web pages, connect them to an Oracle database, and use the power of PL/SQL to create a dynamic, database-driven, Web front-end application. The application presented in this book includes PL/SQL procedures developed using both PL/SQL Web Toolkit and PSP approaches, so that you learn and evaluate different development strategies. This hands-on approach gives you the opportunity to address many of the day-to-day challenges that a PL/SQL Web developer faces. Once you create the application, you should find you are ready to apply your knowledge to other projects.
Putting all these various elements together to make an Oracle Web Application is much like preparing tapas, a Spanish meal comprised of many different appetizer-sized dishes. The beauty of tapas is the way individual elements work together to create a complex and delicious meal. That complexity is also a characteristic of Web programming. To achieve the results you desire, you must combine your knowledge of many different areas, and how they interact. This can be a tricky and frustrating process, but ultimately very powerful, and ideally very satisfying as well.
This book is intended for anyone who needs an introduction to Web application programming with Oracle's PL/SQL language.
Readers are expected to be familiar with Oracle's SQL and PL/SQL languages. This book assumes you have the Oracle knowledge that can be obtained from the companion books in this series: Oracle SQL Interactive Workbook by Alice Rischert (Prentice Hall), and Oracle PL/SQL Interactive Workbook by Ben Rosenzweig and Elena Silvestrova (Prentice Hall). The ideal readers are those with some experience with Oracle relational databases. This book reviews basic PL/SQL concepts, particularly those that are helpful in building the Web application you create by completing the exercises in this book.
The content of this book is based on the material taught in the Database Application Development and Design concentration of Columbia University's Computer Technology and Applications (CTA) program in New York City. The student body is rather diverse, in that there are some students who have years of experience with Information Technology (IT) and programming, but no experience with building a Web application and then there are those with absolutely no experience in either IT or programming. The content of the book, like the class, is balanced to meet the needs of both extremes. The exercises in this book can be used as a lab and homework to accompany the lectures in such a course on Web application development.
At the companion Web site (http://www.phptr.com/boardman/) you will find three very important items:
All of the exercises and questions are based on a sample database schema called STUDENT. The files required to create and install this STUDENT schema are downloadable from the Web site.
In addition to required files and application source code, the Web site will have other features like additional review questions, a message board and periodically updated information about and errata for the book.
You should visit the companion Web site to this book (www.phptr.com/boardman) to download the STUDENT schema and install it in your database.
There are software programs, as well as knowledge requirements, necessary to complete the exercises in this book.
Oracle 9i Enterprise Edition and Oracle 9i Personal Edition include the Oracle 9i database and SQL*Plus, as well as a core version of the Oracle 9iAS. Further information about installing and configuring the 9i Application Server is provided in Chapter 2, "Oracle 9iAS."
There are various ways to obtain Oracle software. The educational version of this book comes with CDs containing the Oracle software for educational purposes. Oracle also offers trial versions of Oracle 9i for evaluation purposes. These CDs can be purchased at the Oracle Store (http://oraclestore.oracle.com).
Readers are encouraged to join the Oracle Technology Network, or Technet, (http://technet.oracle.com) Oracle's free community for sharing technical information. There is no fee to register with TechNet and some software is available for free download from TechNet for registered users. All Oracle documentation can also be found at Oracle's document site (http://docs.oracle.com).
You should be familiar with using SQL*Plus to execute SQL statements (refer to the other book in the Prentice Hall Interactive Workbook series on this topic, Alice Rischert's Oracle SQL Interactive Workbook). You should also be familiar with compiling PL/SQL programs (refer to Rosenzweig/Silvestrova's Oracle PL/SQL Interactive Workbook).
As you progress through the exercises in this book, you will build your own Oracle Web application. It serves as a helpful, real-world example and a context for the material covered. Employing a hands-on approach is an excellent way to truly learn new material. To gain the maximum benefit this book has to offer, readers are strongly urged to follow along with the exercises. Once you create the application, you should find you are ready to apply your knowledge to other projects.
The STUDENT schema (Appendix A) contains tables and other objects meant to keep information about a registration and enrollment system for a fictitious university. There are tables in the system that store data about students, courses, instructors, and so on. In addition to storing contact information (addresses and telephone numbers) for students and instructors, and descriptive information about courses (costs and prerequisites), the schema also keeps track of the sections for particular courses, as well as the sections in which students have enrolled.
The section and enrollment tables are two of the most important tables in the schema. The section table stores data about the individual sections that have been created for each course. Each section record also stores information about where and when the section will meet, and which instructor will teach the section. The section table is related to the course table and the instructor table.
The enrollment table is equally important, because it keeps track of which students have enrolled in which sections. Each enrollment record also stores information about the student's grade and enrollment date. The enrollment table is related to the student table and the section table.
Furthermore, the schema contains a number of other tables that manage grading for each student in each section.