Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series) (Paperback)

~ (Author), (Author)

Editorial Reviews

Product Description

Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

From the Back Cover

The Ultimate Resource on Oracle Database 10g

Get thorough coverage of Oracle Database 10g from the most comprehensive reference available, published by Oracle Press. With in-depth details on all the new features, this powerhouse resource provides an overview of database architecture and Oracle Grid Computing technology, and covers SQL, SQL*Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java programming in the Oracle environment. You’ll also find valuable database administration and application development techniques, plus an alphabetical reference covering major Oracle commands, keywords, features, and functions, with cross-referencing of topics.

• Install Oracle Database 10g or upgrade from an earlier version
• Execute SQL queries
• Perform complex searches easily with regular expression functions
• Implement security measures using Virtual Private Databases (VPDs)
• Move data with SQL*Loader and Data Pump
• Replicate data and aggregations using materialized views
• Execute flashback queries to recover data or see its changes over time
• Create triggers, stored procedures, and packages with PL/SQL
• Develop applications with JDBC and XML
• Work with Oracle Database 10g Real Application Clusters (RAC) and grid technologies
• Take advantage of the new tuning features

CD-ROM includes a searchable electronic book and all code examples from the book.

About the Author: Kevin Loney is a senior technical management consultant with TUSC, a Chicago-based consultancy providing Oracle solutions. He has been an Oracle developer and DBA since 1987, and has written for Oracle Magazine and Oracle Press since 1990. In 2002, he was named Oracle Magazine’s Editors’ Choice as Consultant of the Year. He is a frequent and highly rated speaker at local and international Oracle user groups.

See all Editorial Reviews

Product Details

• Paperback: 1200 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (May 5, 2004)
• Language: English
• ISBN-10: 0072253517
• ISBN-13: 978-0072253511
• Product Dimensions: 9 x 7.4 x 2.9 inches
• Shipping Weight: 5 pounds (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars  See all reviews (20 customer reviews)
• Amazon.com Sales Rank: #73,428 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #19 in	Books > Computers & Internet > Databases > Relational Databases
  #34 in	Books > Computers & Internet > Databases > Oracle
  #73 in	Books > Computers & Internet > Software > Databases

Customer Reviews

Most Helpful Customer Reviews

12 of 12 people found the following review helpful:

5.0 out of 5 stars Indispensable, October 13, 2004

By	Chris A. Ostrowski "Oski" (highlands ranch, co USA) - See all my reviews (REAL NAME)

It didn't seem possible that Mr. Loney could surpass the excellence of his previous books, but I have found "10g: The Complete Reference" to be the most comprehensive and well-written Oracle book on the market today. Most of 10g's new features are complex and can be misapplied if not understood thoroughly. Mr. Loney provides DBAs and developers with clean, concise writing and relevant examples that allow developers and DBAs to exploit the new features of Oracle 10g quickly and appropriately. The beginning sections on Oracle fundamentals should be required reading for all Oracle professionals. His wealth of experience is evident throughout the book. Indispensable for anyone serious about developing or managing Oracle databases.

27 of 33 people found the following review helpful:

5.0 out of 5 stars from the author, September 23, 2004

By	KEVIN LONEY - See all my reviews (REAL NAME)

For those who have seen the prior editions of this book:

The new version is 47 chapters plus the Alphabetical Reference. New chapters include:
Installing Oracle 10g
Upgrading to Oracle 10g (from 9i)
Using the regular expression functions (REGEXP_LIKE, REGEXP_SUBSTR, REGEXP_INSTR, REGEXP_REPLACE)
Using Virtual Private Databases
Using DataPump Export and DataPump Import
Using Flashback Version Queries
Flashback Table (via the Recyclebin)
Flashback Database
Writing dynamic PL/SQL
Case Studies in performance tuning
10g AS
RAC
Grid Management

Additionally, the older chapters have been revised to include coverage of features such as ASM, the Quick Tune options, dynamic memory management, new functions and commands, datatype changes, data dictionary changes, and much much more.

-Kevin Loney.

8 of 9 people found the following review helpful:

5.0 out of 5 stars Easy to read, great info, December 3, 2004

By	Nicolas DH "Nico" (europe, land of the wise) - See all my reviews

As a newbie to Oracle, I found the book easy to follow throughout the chapters. Each time digging in more complex matters. This was a great help!