Oracle9i: The Complete Reference (Paperback)

by Kevin Loney (Author), George Koch (Author) "For an Oracle9i application to be built and used rapidly and effectively, users and developers must share a common language and a deep and common..." (more)
Key Phrases: Alphabetical Reference, Oracle Database Cache, Oracle Net (more...)

Editorial Reviews

Product Description
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.

From the Back Cover
The Renowned Oracle Resource--Fully Updated for Oracle9i

Get comprehensive information on all the features of Oracle9i. Written by best-selling authors and Oracle gurus Kevin Loney, George Koch, and the experts at TUSC, Oracle9i: The Complete Reference covers critical relational, object-relational, and Web database concepts, as well as SQL, SQL*PLUS, PL/SQL, Java, JDBC, SQLJ, and XML programming. You'll also get full details on database administration techniques--and much more. This authoritative volume is a must-have tool for all Oracle professionals.

• Use flashback queries to see data as it existed prior to commits
• Create, query, and manage external tables
• Create partitions, indexes, and tablespaces
• Execute and tune SQL queries
• Produce sophisticated reports using SQL*PLUS
• Load data from external files into Oracle database tables with SQL*Loader
• Create triggers, stored procedures, functions, and packages with PL/SQL
• Implement types, object views, and methods
• Develop robust database applications with SQLJ, JDBC, and XML
• Take advantage of the Oracle9i data dictionary and optimizer
• Tour the components of Oracle9i Application Server (Oracle9iAS)
• Manage, tune, back up, and recover Oracle9i databases
• Learn anytime, anywhere with a 90-day Oracle University Professional subscription. Details on CD-ROM

Bonus CD includes fully searchable electronic book, complete listings of all tables, and an Oracle9i "Information & Documentation Kit" featuring Release 2 New Features White Paper and selected documentation.

See all Editorial Reviews

Product Details

• Paperback: 1256 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (August 16, 2002)
• Language: English
• ISBN-10: 0072225211
• ISBN-13: 978-0072225211
• Product Dimensions: 9 x 7.1 x 2.4 inches
• Shipping Weight: 4.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars See all reviews (10 customer reviews)
• Amazon.com Sales Rank: #352,410 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #83 in

  Books > Computers & Internet > Certification Central > Publisher > Osborne-McGraw-Hill

Customer Reviews

Most Helpful Customer Reviews

21 of 22 people found the following review helpful:

5.0 out of 5 stars Solid coverage, August 29, 2002

By A Customer

This is the one I've been waiting for. It's got coverage of the 9i features like external tables and updates the older chapters to include features. I hadn't even heard about multitable inserts before this book. The CD has 9i R2 docs as well as the book scripts. Overall, more in-depth coverage than the 9i New Features book but the new features are more integrated to old text so you may have to read a little more but it's worth it.

12 of 12 people found the following review helpful:

5.0 out of 5 stars Great reference, August 25, 2003

By A Customer

I cannot keep this book on my desk my cube and have finally ordered more copies for the rest of the crew. It is a terrific reference for anyone using or developing Oracle products. It is very well-written and contains an index that should be a model to the writers and editors of all technical manuals.

19 of 21 people found the following review helpful:

5.0 out of 5 stars The Best book to Start Learning Oracle, October 22, 2003

By	Kalyan A Samaddar (India) - See all my reviews

This is the book to start learning Oracle. This book assume that you know nothing and from there it builds your Oracle Skills. Oracle is very vast but this book has nicely covered all the basic aspects of Oracle that you will need in your day to activity. No doubt that this book will not make you an Oracle Expert but definitely you will learn to move forward. This is the starting point.... This book will make your base for Oracle.