Skip to main content

Oracle8i For Dummies, 2nd Edition

Oracle8i For Dummies, 2nd Edition

Carol McCullough-Dieter, Ned Dana (Foreword by)

ISBN: 978-0-764-50798-4

Dec 2000

408 pages

Select type: Paperback

Product not available for purchase


In Oracle8i For Dummies, Second Edition, author Carol McCullough takes the complexity out of the features available in Oracle8i Release 2 and Enterprise Manager version 2.1.4 and makes them easy to understand. She'll uncover all you need to know about features like built-in support for XML and Enterprise Java Beans, new security options for Internet applications, and new performance and tuning tools included with Enterprise Manager. With her easy-to-follow examples, you'll quickly become familiar with the database and tools and be ready to put them to work.


Part I: Road Map.

Chapter 1: A Quick Tour of Oracle8i.

Chapter 2: Data Whaaaat? A Database Primer.

Chapter 3: SQL Nuts and Bolts.

Chapter 4: Object SQL: The New Stuff.

Chapter 5: Using the Enterprise Manager DBA Tools.

Part II: Getting Started.

Chapter 6: The Relational Model and You.

Chapter 7: Diagramming Your World.

Chapter 8: Getting Familiar with Oracle8i Data-Dictionary Views.

Chapter 9: Oracle's User.

Part III: Putting Oracle8i to Work.

Chapter 10: Defining Tables, Tablespaces, and Columns.

Chapter 11: Creating Object Types, Objects, and References.

Chapter 12: Security Options: Roles and Grants.

Chapter 13: Views and Synonyms: Do You See What I See?

Chapter 14: Oracle Portal: The Best New Tool for the Internet.

Chapter 15: Java and the Internet Database.

Chapter 16: XML and Enterprise Java Beans.

Chapter 17: The Five Ws of Safeguarding Your Data.

Part IV: Tuning Up and Turbocharging.

Chapter 18: What's Slowing Down Your Query?

Chapter 19: Speeding Up Queries with Keys and Indexes.

Chapter 20: Correcting Flaws.

Part V: The Part of Tens.

Chapter 21: Ten Tips for Good Design.

Chapter 22: Ten Handy Oracle8i Internet Features.

Part VI: Appendix.

Appendix: Glossary.


Book Registration Information.
Sample Code

Welcome to the on-line portion of Oracle8i For Dummies! You'll find sample code from nearly every chapter in the book right here.

Follow these steps to download all the sample code from the book in one neatly zipped file:

    1. Click the link:

      Your computer asks where you want to save the file.

    2. Choose a location on your hard drive to download the file to and then click OK.

      The compressed file downloads to your hard drive. Your browser might automatically extract the zipped files by launching WinZip itself and asking if you'd like to extract the compressed file. Otherwise, start WinZip yourself, locate the file on your hard drive, and extract the files manually.

      For more info on WinZip, see

    3. Extract the text files from the compressed file and save them into a directory of your choice.

      The sample code will automatically be extracted into directories for each chapter. As you work in each chapter, you will find the sample code under the directory with that chapter name.