Cover image for Oracle8i : the complete reference
Oracle8i : the complete reference
Loney, Kevin.
Personal Author:
Tenth anniversary edition.
Publication Information:
Berkeley : Osborne McGraw-Hill, [2000]

Physical Description:
xxx, 1313 pages : illustrations ; 24 cm + 1 computer laser optical disc (4 3/4 in.)
General Note:
Includes index.
Title Subject:
Subject Term:
Added Author:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D3 L6624 2000 Book and Software Set Central Closed Stacks

On Order



Provides an understanding of database development on the Internet.

Table of Contents

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