Oracle Web Applications: PL/SQL Developer's Intro: Developer's Introduction - Softcover

Odewahn, Andrew

Softcover

ISBN 10: 1565926870 ISBN 13: 9781565926875

Publisher: O'Reilly Media, 1999

Synopsis

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).Background: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.Contains: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.

About this title

Review

Oracle databases sit behind a large number of Web servers. The latest release, Oracle 8i, is sold as an Internet database and gives developers tools to build Web applications. Oracle Web Applications is a guide for using Oracle 8i for content management, application development, and application integration. You'll learn about its support for the latest Internet technologies, including XML and Oracle's WebDB application development tools. There's also an overview of the InternetLite technologies that allow you to deliver Oracle databases to handhelds like the Palm organizer.

The real meat of the book begins with two chapters that cover building Web applications in WebDB and Oracle's Application Server. The rest of the book goes into plenty of detail and provides lots of code on how to use Oracle's PL/SQL programming language to generate HTML and XML. When you've worked your way through this, you should be ready to start working with Oracle 8i and the Web--and you should be ready to begin linking Oracle databases to the Internet. Code samples and plenty of tips make this an excellent developer's reference. --Simon Bisson, Amazon.co.uk

About the Author

Andrew Odewahn is a writer and software entrepreneur. With an MBA from New York University's Stern School of Business, he has an exceptional ability to find creative yet practical solutions to real-life business problems. The author of Oracle Web Applications (O'Reilly, 1999) and co-author of Oracle PL/SQL Workbook (O'Reilly, 2000), Andrew specializes in database technology. While not writing or designing software, he and his wife travel whenever they can. Their adventures include riding Lipizzaner stallions at a Slovenian casino, speeding down an alpine slide deep in the jungles of Vietnam, hiking (and riding the occasional ski lift!) across the Swiss Alps, hosteling in a Soviet-era sanitarium, and circumnavigating New Zealand's "Mount Doom." They currently live in Maine.

Edition details

• Publisher: O'Reilly Media
• Publication date: 1999
• ISBN 10: 1565926870
• ISBN 13: 9781565926875
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 241