Oracle8i: The Complete Reference (Book/CD-ROM Package)
10th Edition
Published on 16. June 2000
Book
Hardback
1392 pages
978-0-07-212364-7 (ISBN)
Description
This is the most definitive resource available on Oracle8i and is a must-have for every Oracle professional. The book describes how to master all the powerful features of Oracle8i--the most complete and comprehensive platform for building and deploying Internet and enterprise applications. Written by best-selling Oracle author, Kevin Loney, and a former senior vice president of Oracle Corporation, George Koch, Oracle8i: The Complete Reference covers all the components of this robust product. The reader will learn key relational and object-relational database concepts, SQL, PL/SQL, SQLJ, and Java programming techniques, backup, recovery, and tuning methods, and much more. A fully searchable version of the book and reusable code are included on the CD-ROM.
More details
Edition
10th ANNIVERSARY ed.
Language
English
Place of publication
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Edition type
Annotated edition
Illustrations
75 illustrations
Dimensions
Height: 239 mm
Width: 188 mm
Thickness: 71 mm
Weight
2268 gr
ISBN-13
978-0-07-212364-7 (9780072123647)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine
Content
Section I: Critical Database Concepts. Chapter 1: Sharing Knowledge and Success. Chapter 2: The Dangers in a Relational Database. Section II: SQL: Going from Beginner to Expert. Chapter 3: The Basic Parts of Speech in SQL. Chapter 4: The Basics of Object-Relational Databases. Chapter 5: Basic SQLPLUS Reports and Commands. Chapter 6: Getting Text Information and Changing It. Chapter 7: Playing the Numbers. Chapter 8: Dates: Then, Now, and the Difference. Chapter 9: Conversion and Transformation Functions. Chapter 10: Grouping Things Together. Chapter 11: When One Query Depends Upon Another. Chapter 12: Some Complex Possibilities. Chapter 13: Building a Report in SQLPLUS. Chapter 14: Changing Data: Insert, Updated, and Delete. Chapter 15: Advanced Use of Functions and Variables. Chapter 16: DECODE: Amazing Power in A Single Word. Chapter 17: Creating, Dropping and Altering Tables, Partitions, and Views. Chapter 18: By What Authority? Chapter 19: Changing the ORACLE Surroundings. Chapter 20: Tips/Techniques. Chapter 21: Accessing Remote Data. Chapter 22: An Introduciton to PL/SQL. Chapter 23: Triggers. Chapter 24: Procedures, Functions, and Packages. Chapter 25: Implementing Types, Ojbective views, and Methods. Chapter 26: Collectors (Nested Tables and Varying Arrays). Chapter 27: Using Large Objects (LOBs). Chapter 28: Snapshots. Chapter 29: Using Context for Text Searches. Chapter 30: New Content. Chapter 31: Advanced Object-Oriented Concepts. Section III: Java in Oracle. Chapter 32: An Introduction to Java. Chapter 33: JDBG and SQLJ. Chapter 34: Java Stored Procedures and Enterprise Java Beans. Chapter 35: Web-Based Architecture Issues. Section IV: Ilitchhiker's Guides. Chapter 36: Ilitchhiker's Guide to the Data Dictionary. Chapter 37: Ilitchhiker's Guide to the Optimizer. Chapter 38: Ilitchhiker's Guide WebDB. Chapter 39: Ilitchhiker's Guide to Database Administration. Section V: Designing for Performance. Good Design Has a Human Touch. Performance and Design. The Ten Commandments of Ilumane Design.