Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series) 1st Edition

3.9 out of 5 stars 35 customer reviews
ISBN-13: 978-0072253511
ISBN-10: 0072253517
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Rent On clicking this link, a new layer will be open
$13.99 On clicking this link, a new layer will be open
Buy used On clicking this link, a new layer will be open
$19.99 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$59.63 On clicking this link, a new layer will be open
More Buying Choices
17 New from $11.99 67 Used from $0.01
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Save Up to 90% on Textbooks Textbooks
$59.63 FREE Shipping. Only 2 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

  • Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)
  • +
  • Oracle Database 10g DBA Handbook
  • +
  • Oracle Database 10g PL/SQL Programming
Total price: $141.05
Buy the selected items together

Editorial Reviews

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.

About 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
NO_CONTENT_IN_FEATURE



Product Details

  • Series: Oracle Press
  • Paperback: 1369 pages
  • Publisher: McGraw-Hill Education; 1 edition (May 5, 2004)
  • Language: English
  • ISBN-10: 0072253517
  • ISBN-13: 978-0072253511
  • Product Dimensions: 7.4 x 2.6 x 9.1 inches
  • Shipping Weight: 5 pounds (View shipping rates and policies)
  • Average Customer Review: 3.9 out of 5 stars  See all reviews (35 customer reviews)
  • Amazon Best Sellers Rank: #971,835 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Top Customer Reviews

Format: Paperback
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.
Comment 12 of 12 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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.
Comment 27 of 33 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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!
Comment 8 of 9 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
The title says it all. Well there's one additional tidbit of information that's important, there are 1200 pages in this book. In 1200 pages you can include a lot of things. You can include 300 pages on SQL for instance. And some of the new subjects like the new sections on The Grid (that's the g in 10g) are covered here for the first time.

The Grid is coming, as of yet it's just getting started, but in the next edition of this book it'll be a hundred pages, if it isn't a whole book in itself.

As an Oracle professional, at almost any level from developing an application, to tuning the performance, to security, to 'simple' things like installation, this is the one book you need to have on your desk ready for immediate use.

After this, it's kind of hard to say much about this book. You may want individual books on tuning or security or whatever if that is your primarily responsibility, but here in one volume is the basic for the whole thing.
Comment 12 of 15 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
With a 1200+ page book, entitled "The Complete Reference", I would have expected much more information about proper configuration. Properly configuring Oracle (I'm running it on Unix) is no trivial matter and I found this book to be severely lacking. While it seems like a good reference to have (hence 3 / 5 stars), it looks like I'm going to have to look for other resources.
Comment 6 of 7 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I have used Kevin Loney's texts, both the Reference and the DBA editions on Oracle database from the heady Oracle 7 days and have found them to be most acurate, complete and exceptionally easy to use and to quickly locate required materials. The examples given are very clear and they work!

The 10g texts are remarkable in their coverage and clarity. Many thanks Kevin and keep up the good work !
Comment 5 of 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This sounded like a good book, judging by the reviews here, but being relatively new to the Oracle world, I haven't found this book terribly useful so far. Oracle's docs have been much more helpful and detailed. I was hoping for a book that shared the author's experience and tips and helped the reader make decisions, but this seems to be largely a command reference, covering many topics superficially.
1 Comment 14 of 19 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Based on the reviews, I bought this book some time ago. Unfortunately, my colleagues and I have not found much use for it. It covers quite some subjects but rather briefly. There is almost half the book on SQL and PL/SQL which is too much for me for a "Complete Reference" I expected more info on configuring oracle, dataguard, ASM and Enterprise Manager but was disappointed.
For an SQL/PLSQL novice, this must be the reference book, very complete with many examples to guide you. For a DBA already familiar with this language, the book would contain too little specific info on new and important 10g topics such as ASM, dataguard, flashback etc...
Conclusion for me: when I want to look up something on Oracle, I go for OTN manuals or metalink or google instead of this book.
Comment 2 of 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)
This item: Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)
Price: $59.63
Ships from and sold by Amazon.com

Want to discover more products? Check out this page to see more: store locator