Oracle Web Applications: PL/SQL Developer's Introduction (Paperback)

Andrew Odewahn

  • 出版商: O'Reilly
  • 出版日期: 1999-09-11
  • 定價: $990
  • 售價: 1.0$99
  • 語言: 英文
  • 頁數: 256
  • 裝訂: Paperback
  • ISBN: 1565926870
  • ISBN-13: 9781565926875
  • 相關分類: OracleSQL
  • 立即出貨(限量)



This compact guide provides the jump-start Oracle developers need to make the transition from traditional programming to the development of useful Web applications for Oracle8i. Even readers who start out knowing nothing about HTML, PL/SQL, or Oracle's other tools will learn how to create simple Web applications in a matter of days. The book focuses on Oracle8i, but also covers Web development for earlier Oracle versions (Oracle8 and Oracle7).


The explosion in the use of the Internet and the Web has resulted in a whole new way of doing business. Developers who only yesterday were using COBOL to write accounts payable systems are now being asked to create a broad range of new Internet-based applications ranging from electronic commerce (e-commerce) Web sites to internal data warehouses to enterprise resource planning (ERP) systems. Unfortunately, the filesystem architectures of most Web systems aren't up to the task. The new breed of Web applications -- which are quickly becoming critical resources that companies need to survive -- demand a platform that provides production-quality tools for content management, application development, and application integration. And current Web techniques are inadequate in many ways.

Oracle8i, Oracle's "Internet database," gives Web developers a way to build Web technology on top of a relational database, rather than on a traditional filesystem. With Oracle8i, companies can apply well understood, reliable, production-quality database methodologies to Web content management. Oracle8i also supports a wide variety of application development platforms and tools that are tightly integrated to the core database. Finally, Oracle8i supports technologies that help companies tie their Web-based applications into legacy applications.

There is a lot to learn in Oracle8i. Not only does it enhance basic database features, it introduces Java and a variety of Web development tools. Oracle8i provides a soup-to-nuts platform for Web site and Web application development that extends traditional database concepts to Web content. It replaces the traditional filesystem used by most Web servers with a database management system.

Many users are intimidated by the vast array of new technologies in Oracle8i. And yet, they are under pressure to use these technologies to build complex Web applications right now. This book gives such users a way to start using Oracle8i immediately to create useful Web applications. It is a concise, easy-to-read guide to the basic technologies developers need to understand in order to build Web applications.


The book describes the following Web development tools:

  • PL/SQL-- a structured programming language that combines procedural constructs and standard SQL. It offers such features as cursors, loops, conditional and sequential control statements, exception handlers, records, tables, and constructs for developing modular code (functions, procedures, and packages).

  • PL/SQL Toolkit -- a set of PL/SQL packages supplied by Oracle for use in developing Web applications.

  • HTML -- an ASCII-based markup language used to create Web pages.

  • WebDB -- A software system for building, monitoring, and creating content-driven Web sites; it allows users to use a Web browser to access and store information in the Oracle8i database.

  • Oracle Application Server (OAS) -- an extensible Web server that uses plug-in programs called cartridges to allow database-integrated Web systems to be developed in a variety of languages (e.g., PL/SQL, Java, Perl).

  • XML -- An emerging standard for creating self-describing documents. It is similar to HTML but allows you to create your own markup tags. XML is expected to be a key technology in electronic commerce systems.

  • The book also presents several fully realized sample Web applications that will teach you how to build such applications of your own.

NOTE: Although this book touches on the Java features of Oracle8i, it doesn't cover Java development per se. Switching to Java represents an enormous change for most Oracle developers. This book provides an evolutionary path for readers who want to do useful Oracle8i Web development now, using mostly familiar tools. Additional books will provide Java training for those who have mastered these Web tools and want to take the next step.


- PL/SQL:一種結構化編程語言,結合了程序化構造和標準SQL。它提供了游標、循環、條件和順序控制語句、異常處理程序、記錄、表和用於開發模塊化代碼(函數、過程和包)的結構等功能。
- PL/SQL Toolkit:Oracle提供的一套用於開發Web應用程序的PL/SQL包。
- HTML:一種基於ASCII的標記語言,用於創建Web頁面。
- WebDB:一個用於構建、監控和創建內容驅動的Web站點的軟件系統;它允許用戶使用Web瀏覽器訪問和存儲Oracle8i數據庫中的信息。
- Oracle Application Server(OAS):一個可擴展的Web服務器,使用稱為插件程序的軟件模塊,允許以多種語言(如PL/SQL、Java、Perl)開發集成數據庫的Web系統。
- XML:一種新興的創建自描述文檔的標準。它類似於HTML,但允許您創建自己的標記標籤。預計XML將成為Web應用程序開發的重要技術。