Oracle9i: The Complete Reference

Be the first to write a review

Overview

Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. This is a must-have reference for all Oracle professionals.
Read More Show Less
... See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Paperback)
  • All (30) from $1.99   
  • New (3) from $65.0   
  • Used (27) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$65.00
bluehouse
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$65.00
bluehouse
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$78.43
valuebooks
Seller since Mon Aug 11 10:50:07 EDT 2014

Feedback rating:

(98)

Condition: New
New New condition. Free track. Fast shipping! Satisfaction guaranteed!

Ships from: Media, PA

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

More About This Book

Overview

Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. This is a must-have reference for all Oracle professionals.
Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
In Oracle 9i: The Complete Reference, legendary Oracle wizard Kevin Loney and former Oracle senior VP George Koch have done it yet again: They’ve authored the most thorough Oracle 9i reference ever created.

Of course, all the latest Oracle 9i functions and commands are covered, both throughout the book and in an extensively cross-referenced Alphabetic Reference that’s unparalleled in its usefulness. You’ll find detailed new coverage of Oracle 9i’s Virtual Private Database, a remarkably flexible tool for implementing security; as well as Flashback Queries, which allow users to recover from mistakes easily and gracefully. You’ll also find new, quick "Hitchhiker's Guides" to the Oracle 9i Data Dictionary, Optimizer, and Application Server, and on Oracle 9i’s XML support.

You name it, it’s here. After a thorough review of fundamental database concepts, Loney and Koch present 24 full chapters on SQL, SQL*Plus, and PL/SQL. That’s followed by a complete section on implementing and utilizing object-relational databases, and three full chapters on Java in Oracle -- including coverage of both JDBC and SQLJ programming, as well as Java stored procedures. Only one thing’s bigger than this book: its value to the working Oracle professional. Bill Camarda

Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks For Dummies®, Second Edition.

From The Critics
The latest version of this popular guide introduces the fundamental commands and techniques used in Oracle 9i database systems, and how to develop applications using Oracle and SQL. The authors also review PL/SQL structures, object-oriented and Java features in the Oracle database, the data dictionary, database optimizers, and the application server. The CD-ROM contains an electronic version of the book and tables. Annotation c. Book News, Inc., Portland, OR
Read More Show Less

Product Details

  • ISBN-13: 9780072225211
  • Publisher: McGraw-Hill Companies, The
  • Publication date: 8/28/2002
  • Series: Osborne Oracle Press Series
  • Edition description: BOOK & CD
  • Edition number: 1
  • Pages: 1256
  • Product dimensions: 7.34 (w) x 9.10 (h) x 2.42 (d)

Meet the Author

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.
Read More Show Less

Table of Contents

Acknowledgments
Preface
Introduction
1 Sharing Knowledge and Success 3
2 The Dangers in a Relational Database 15
3 The Basic Parts of Speech in SQL 41
4 The Basics of Object-Relational Databases 69
5 Introduction to Web-Enabled Databases 83
6 Basic SQL[superscript *] PLUS Reports and Commands 91
7 Getting Text Information and Changing It 113
8 Playing the Numbers 141
9 Dates: Then, Now, and the Difference 165
10 Conversion and Transformation Functions 193
11 Grouping Things Together 205
12 When One Query Depends upon Another 219
13 Some Complex Possibilities 237
14 Building a Report in SQL [superscript *]PLUS 255
15 Changing Data: insert, update, merge, and delete 279
16 Advanced Use of Functions and Variables 297
17 DECODE and CASE: if, then, and else in SQL 311
18 Creating, Dropping, and Altering Tables and Views 325
19 By What Authority? 355
20 Changing the Oracle Surroundings 379
21 Using SQL[superscript *] Loader to Load Data 393
22 Accessing Remote Data 409
23 Using Materialized Views 423
24 Using Oracle Text for Text Searches 447
25 Using External Tables 465
26 Using Flashback Queries 479
27 An Introduction to PL/SQL 489
28 Triggers 509
29 Procedures, Functions, and Packages 529
30 Implementing Types, Object Views, and Methods 551
31 Collectors (Nested Tables and Varying Arrays) 567
32 Using Large Objects 581
33 Advanced Object-Oriented Concepts 607
34 An Introduction to Java 627
35 JDBC and SQLJ Programming 645
36 Java Stored Procedures 663
37 The Hitchhiker's Guide to the Oracle9i Data Dictionary 673
38 The Hitchhiker's Guide to the Oracle Optimizer 721
39 The Hitchhiker's Guide to Oracle9iAS 769
40 The Hitchhiker's Guide to Database Administration 791
41 The Hitchhiker's Guide to XML in Oracle 827
Alphabetical Reference 844
Index 1201
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
Sort by: Showing 1 Customer Reviews

  • Anonymous

    Posted Fri May 09 00:00:00 EDT 2003

    Not quite complete

    While this is a pretty good reference book, I bought it expecting to get complete instructions on doing massive data loading using Oracle's XML capabilities. Just when I was getting to the 'good stuff', the authors reference the Oracle utility manual.

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.
Sort by: Showing 1 Customer Reviews
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)