rent-now

Rent More, Save More! Use code: ECRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

9780072225211

Oracle9i : The Complete Reference

by
  • ISBN13:

    9780072225211

  • ISBN10:

    0072225211

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2002-08-16
  • Publisher: McGraw-Hill Osborne Media
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $79.95

Summary

The '¬Smust have'¬ reference for all Oracle professionals is now updated with the latest information on Oracle9i.

Author Biography

George Koch is a former senior vice president of Oracle Corporation.

Table of Contents

PART I: Critical Database Concepts

1: Sharing Knowledge and Success

2: The Dangers in a Relational Database

3: The Basic Parts of Speech in SQL

4: The Basics of Object-Relational Databases

5: Introduction to Web-Enabled Databases

PART II: SQL and SQL*PLUS

6: Basic SQL*PLUS Reports and Commands

7: Getting Text Information and Changing It

8: Playing the Numbers

9: Dates: Then, Now, and the Difference

10: Conversion and Transformation Functions

11: Grouping Things Together

12: When One Query Depends upon Another

13: Some Complex Possibilities

14: Building a Report in SQL*PLUS

15: Changing Data: insert, update, merge, and delete

16: Advanced Use of Functions and Variables

17: DECODE and CASE: if, then, and else in SQL

18: Creating, Dropping, and Altering Tables and Views

19: By What Authority?

20: Changing the Oracle Surroundings

21: Using SQL*Loader to Load Data

22: Accessing Remote Data

23: Using Materialized Views

24: Using Oracle Text for Text Searches

25: Using External Tables

26: Using Flashback Queries

PART III: PL/SQL

27: An Introduction to PL/SQL

28: Triggers

29: Procedures, Functions, and Packages

PART IV: Object-Relational Databases

30: Implementing Types, Object Views, and Methods

31: Collectors (Nested Tables and Varying Arrays)

32: Using Large Objects

33: Advanced Object-Oriented Concepts

PART V: Java in Oracle

34: An Introduction to Java

35: JDBC and SQLJ Programming

36: Java Stored Procedures

PART VI: Hitchhiker’s Guides

37: The Hitchhiker’s Guide to the Oracle9i Data Dictionary

38: The Hitchhiker’s Guide to the Oracle Optimizer

39: The Hitchhiker’s Guide to Oracle9iAS

40: The Hitchhiker’s Guide to Database Administration

41: The Hitchhiker’s Guide to XML in Oracle

PART VII: Alphabetical Reference Reference

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program