Oracle Database 11g The Complete Reference (Oracle Press) [Hardcover]

Kevin Loney (Author)

Book Description

Publication Date: December 17, 2008 | ISBN-10: 0071598758 | ISBN-13: 978-0071598750 | Edition: 1

The Definitive Guide to Oracle Database 11g

Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included.

• Install Oracle Database 11g or upgrade from an earlier version
• Create database tables, sequences, indexes, views, and user accounts
• Construct SQL statements, procedures, queries, and subqueries
• Optimize security using virtual private databases and transparent data encryption
• Import and export data using SQL*Loader and Oracle Data Pump
• Use SQL replay, change management, and result caching
• Avoid human errors using flashback and automatic undo management
• Build and tune PL/SQL triggers, functions, and packages
• Develop database applications using Java, JDBC, and XML
• Optimize availability and scalability with Oracle Real Application Clusters

Editorial Reviews

About the Author

Kevin Loney was named Consultant ofthe Year by ORACLE Magazine in 2002. He is an internationally recognized Oracle expert who frequently presents at Oracle user conferences in North America and Europe where he is regularly among the highest-rated presenters.

Product Details

• Hardcover: 1368 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (December 17, 2008)
• Language: English
• ISBN-10: 0071598758
• ISBN-13: 978-0071598750
• Product Dimensions: 9.3 x 7.6 x 2.2 inches
• Shipping Weight: 4.8 pounds (View shipping rates and policies)
• Average Customer Review: 3.8 out of 5 stars  See all reviews (9 customer reviews)
• Amazon Best Sellers Rank: #124,950 in Books (See Top 100 in Books)

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

8 of 9 people found the following review helpful:

2.0 out of 5 stars Expensive Paperweight, September 24, 2010

By 

Benjamin C Lewis - See all my reviews

This review is from: Oracle Database 11g The Complete Reference (Oracle Press) (Hardcover)

If you have no internet access, this book is better than nothing, but otherwise stick with the free online books and docs provided by Oracle. Indeed, the last 1/3 or so of this book is just reference material copied directly from Oracle's free docs, but is more difficult to navigate without the hyperlinked crossreferences.

The book is not "complete" as the title suggests, not covering all new features (case-insensitivity using NLS_SORT, NLS_COMP is just one example).

Additionally, not all the information is accurate -- the author does not even know what the term "relational database" means, he thinks "relations" have something to do with foreign keys. A common misconception yes, but worrisome from a database "expert". I also found incorrect syntax in the transportable tablespace section, before I gave up with the book entirely.

Use at your own risk, and consider that the author has given his own book a 5 star rating on this site!

3 of 3 people found the following review helpful:

4.0 out of 5 stars Oracle complete reference, November 13, 2009

By 

Richard John (Vallejo, CA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Oracle Database 11g The Complete Reference (Oracle Press) (Hardcover)

Generally the book is well written , but the approach is for very highly technical individuals. Since I am primary a SQL programmer, about half the book is not what I need. However, I use this book on PL/SQL more than I use the book "Oracle PL/SQL Programming". I found this book is better organized to check syntax on various functions. My DBA is usually checking the book for her job and she has found the book to be helpful for her needs. Overall I would recommend the book as a group reference.

2 of 3 people found the following review helpful:

5.0 out of 5 stars Great reference, November 17, 2009

By 

Will (San Francisco) - See all my reviews
(VINE VOICE)   

This review is from: Oracle Database 11g The Complete Reference (Oracle Press) (Hardcover)

I have been using this book or one of its earlier versions for six years. It does a great job of filling in the blanks for people like me who learned Oracle in the monkey-see monkey-do fashion of on the job training. It continues to be a great reference because it has a great index -- probably the best index in any technical book I own. I can find a term in the index very quickly and then flip to a focused explanation of that term. This usually much faster than flailing around the web doing word searches for the same information. It is an expensive book, but I have saved in frustration what I spent in dollars. It is very difficult to keep it on my desk because it is borrowed so often.