Oracle Web Applications: PL-SQL Developer’s Introduction

Andrew Odewahn9781565926875, 1-56592-687-0

Oracle8i, Oracle’s “Internet database,” introduces a variety of Web development tools that extend traditional database concepts to Web content. With Oracle’s DBMS, you can now build Web technology on top of a relational database, rather than on a traditional filesystem. This approach remedies many of the problems that have slowed down the ability of organizations to build new Web applications and to put their legacy applications on the Web. Many developers are intimidated by the vast array of new technologies in Oracle8i. And yet, they are under pressure to build complex Web applications immediately. This book provides the information you need to start building these applications right away. It is a compact, easy-to-read guide to PL/SQL, HTML, XML, WebDB,and Oracle Application Server (OAS). It also covers the packages in the PL/SQL toolkit and shows several fully realized Web applications. This book provides the jump-start you need to to make the transition from traditional programming to the development of useful Web applications for Oracle8i. Even those who know 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 also covers Web development for earlier Oracle versions (Oracle8 and Oracle7).

---

Table of contents :
Oracle Web Applications: PL/SQL Developer’s Introduction……Page 0
Oracle Web Applications: PL/SQL Developer’s Introduction……Page 1
Preface……Page 2
[Preface] Structure of This Book……Page 4
[Preface] Conventions Used in This Book……Page 6
[Preface] Comments and Questions……Page 8
[Preface] Acknowledgments……Page 10
[Chapter 1] Introduction……Page 12
[Chapter 1] 1.2 Current Web Techniques Are Inadequate……Page 15
[Chapter 1] 1.3 Oracle’s Solution — Oracle8i……Page 20
[Chapter 1] 1.4 A Roadmap to Oracle8i……Page 37
[Chapter 2] Foundations……Page 42
[Chapter 2] 2.2 Server-to-Client Communication……Page 44
[Chapter 2] 2.3 Content Delivery Model……Page 50
[Chapter 2] 2.4 Database Integration……Page 54
[Chapter 2] 2.5 Database Security Review……Page 60
[Chapter 3] WebDB……Page 69
[Chapter 3] 3.2 WebDB Architecture……Page 87
[Chapter 4] Oracle Application Server (OAS)……Page 95
[Chapter 4] 4.2 Creating Dynamic Resources……Page 103
[Chapter 5] HTML……Page 108
[Chapter 5] 5.2 A Whirlwind Tour……Page 113
[Chapter 6] PL/SQL……Page 131
[Chapter 6] 6.2 Programming Constructs……Page 143
[Chapter 6] 6.3 Packages……Page 157
[Chapter 6] 6.4 PL/SQL Tools……Page 164
[Chapter 7] The PL/SQL Toolkit……Page 168
[Chapter 7] 7.2 Text Processing……Page 174
[Chapter 7] 7.3 Maintaining State……Page 191
[Chapter 7] 7.4 Improving Productivity……Page 205
[Chapter 8] Developing Applications……Page 229
[Chapter 8] 8.2 Example 1: An Anonymous Survey……Page 233
[Chapter 8] 8.3 Example 2: A Discussion Forum……Page 246
[Chapter 9] XML……Page 273
[Chapter 9] 9.2 XML Syntax……Page 277
[Chapter 9] 9.3 The Document Type Definition (DTD)……Page 279
[Chapter 9] 9.4 The XML Parser……Page 282
[Chapter 9] 9.5 Example: Generating an XML Invoice from Oracle……Page 284
[Chapter 9] 9.6 PLSXML Utilities and Demos……Page 291
[Chapter 9] 9.7 XML and iFS……Page 293
[Appendix A] Appendix: Resources for the Oracle Web Developer……Page 295
[Appendix A] A.2 Other Publications……Page 298
[Appendix A] A.3 Organizations……Page 299
[Appendix A] A.4 Web Sites……Page 301
[Appendix A] A.5 Discussion Groups……Page 303