#

| Chapter 1 |

# 1. Oracle8i: A Bounty for PL/SQL Developers

Contents:
What's in Oracle8i Release 8.1?
And Then There's Java
New PL/SQL Features Roundup

After long delays, Oracle8i Release 8.1 went into production in 1999. Oracle8i, the "Internet database," is packed with an astounding and intimidating array of powerful new features -- and I don't even work for Oracle any more! Hey, I don't have to use exclamation marks to describe all the great things you can do with Oracle8i Release 8.1!

Whew. Got that out of my system. Do you ever have trouble separating the marketing from the reality with Oracle Corporation? The name of their latest release brings that issue to the fore like never before. "Oracle8i Release 8.1" -- what does all that mean? Here is how I see it: "Oracle8i " -- that's the marketing piece touting the first database for the Internet. "Release 8.1" -- now they're talking my language, the actual database version. I started with Oracle 5.1 and have been steadily pleased with the improvements through Oracle6 (quickly, please) and then Oracle7. Oracle 8.0 was a .0 release and, as a result, many, many organizations around the world paid very little attention to it. Now, finally, we have Oracle 8.1 and I expect that many organizations will move relatively quickly to this release level.

## 1.1 What's in Oracle8i Release 8.1?

What do you get with Oracle 8.1? The list is very long and very impressive ("more than 150 new features," says Oracle). Here are some of the features I have heard about:

- The Aurora Java(TM) Virtual Machine ( JVM) right inside the database

- Support for Java stored procedures ( JSPs)

- i FS, the Internet File System (not currently available at the time of publication)

- Support for the Linux operating system

- inter Media

- Support for SQLJ and JDBC(TM) ( Java Database Connectivity)

- WebDB

- Autonomous transactions

- Invoker rights model

- Many performance improvements

> TIP: Throughout this book, Oracle 8.1 refers to Oracle8i Release 8.1, and PL/SQL 8.1 refers to the Oracle8i

The Oracle8i documentation has a section titled "Getting to Know Oracle8i"; the table of contents for new features is 259 lines long! Is that more than mere mortals can deal with? It sure is more than I can deal with. So I am going to stick with what I know best: PL/SQL. This book focuses almost exclusively on new Oracle8i features that have a direct impact on (or are implemented by) the PL/SQL language. As you will see, even if the focus is constrained to PL/SQL, there are many, many new techniques and technologies to learn, absorb, and then leverage in application environments.

Acknowledgments |  | 1.2 And Then There's Java

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.