Oracle8 Bible

by McCullough-Dieter, Carol; Prem, Jatinder; Chandak, Ramesh; Chandak, Purshottam

• ISBN13: 9780764531989
• ISBN10: 0764531980
• Edition: CD
• Format: Paperback
• Copyright: 1998-06-01
• Publisher: John Wiley & Sons Inc

Summary

The Oracle8 Bible is a comprehensive guide to the Oracle8 Enterprise Package. It supplies in-depth coverage of the latest Oracle8 tools as well as various commands and techniques for effectively managing and delivering large amounts of data with Oracle8. Using step-by-step instructions and plenty of samples, author Carol McCullough-Dieter explains important topics such as Object-relational database design, data backup and recovery, auditing, and partitioning. Part introductory tour, part reference guide, the Oracle8 Bible is an essential resource for novice Oracle developers and veteran database administrators alike.The CD-ROM includes all the samples and SQL code in the book as well as a fully searchable version of Oracle8 Bible.

Table of Contents

Preface	ix	(4)
Acknowledgments	xiii
Part I: Getting Started	1	(120)
Chapter 1: Introducing Oracle8	3	(22)
Chapter 2: Oracle8 Overview	25	(18)
Chapter 3: Concepts	43	(8)
Chapter 4: Primary Tools	51	(50)
Chapter 5: Other Utilities and Tools	101	(20)
Part II: Nuts and Bolts	121	(172)
Chapter 6: Security Manager for Users, Roles, and Profiles	123	(24)
Chapter 7: Schema Manager for Tables	147	(40)
Chapter 8: Schema Manager for Views, Synonyms, and Sequences	187	(16)
Chapter 9: SQL for Queries	203	(22)
Chapter 10: SQL for Data Manipulation	225	(10)
Chapter 11: SQL for Users, Roles, and Profiles	235	(12)
Chapter 12: SQL for Tables	247	(20)
Chapter 13: SQL for Views, Synonyms, and Sequences	267	(10)
Chapter 14: SQL(*)Plus for Reports	277	(16)
Part III: Tuning and Backups	293	(148)
Chapter 15: Performance	295	(18)
Chapter 16: Oracle8 Backup	313	(76)
Chapter 17: Oracle8 Recovery	389	(52)
Part VI: Advanced Topics	441	(222)
Chapter 18: PL/SQL	443	(18)
Chapter 19: Procedures, Packages, Functions, and Triggers	461	(42)
Chapter 20: Auditing	503	(16)
Chapter 21: Multiple Database Instances	519	(36)
Chapter 22: Oracle8 Clusters	555	(14)
Chapter 23: Very Large Databases	569	(30)
Chapter 24: Oracle8 Objects	599	(48)
Chapter 25: Programming with Objects	647	(16)
Part V: Appendixes	663	(428)
Appendix A: Command Reference	665	(414)
Appendix B: About the CD-ROM	1079	(8)
Appendix C: Sample PL/SQL	1087	(4)
Glossary	1091	(12)
Index	1103	(32)
End-User License Agreement	1135	(4)
CD-ROM Installation Instructions	1139