Oracle Database 11g The Complete Reference / Edition 1

Hardcover (Print)
Rent from
(Save 75%)
Est. Return Date: 07/25/2015
Used and New from Other Sellers
Used and New from Other Sellers
from $27.47
Usually ships in 1-2 business days
(Save 65%)
Other sellers (Hardcover)
  • All (12) from $27.47   
  • New (4) from $44.15   
  • Used (8) from $27.47   


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

Product Details

  • ISBN-13: 9780071598750
  • Publisher: McGraw-Hill Professional Publishing
  • Publication date: 12/17/2008
  • Series: Oracle Press Series
  • Edition number: 1
  • Pages: 1368
  • Sales rank: 974,871
  • Product dimensions: 7.50 (w) x 9.20 (h) x 2.10 (d)

Meet 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.

Read More Show Less

Table of Contents

PART I: Critical Database Concepts
Ch 1: Oracle Database 11g Architecture Options
Ch 2: Installing Oracle Database 11g and Creating a Database
Ch 3: Upgrading to Oracle Database 11g
Ch 4: Planning Oracle Applications—Approaches, Risks, and Standards
Ch 5: The Basic Parts of Speech in SQL
Ch 6: Basic SQL*Plus Reports and Commands
Ch 7: Getting Text Information and Changing It
Ch 8: Searching for Regular Expressions
Ch 9: Playing the Numbers
Ch 10: Dates: Then, Now, and the Difference
Ch 11: Conversion and Transformation Functions
Ch 12: Grouping Things Together
Ch 13: When One Query Depends upon Another
Ch 14: Some Complex Possibilities
Ch 15: Changing Data: insert, update, merge, and delete
Ch 16: DECODE and CASE: if, then, and else in SQL
Ch 17: Creating and Managing Tables, Views, Indexes, Clusters, and Sequences
Ch 18: Partitioning
Ch 19: Basic Oracle Security
PART III: Beyond the Basics
Ch 20: Advanced Security—Virtual Private Databases
Ch 21: Advanced Security: Transparent Data Encryption
Ch 22: Working with Tablespaces
Ch 23: Using SQL*Loader to Load Data
Ch 24: Using Data Pump Export and Import
Ch 25: Accessing Remote Data
Ch 26: Using Materialized Views
Ch 27: Using Oracle Text for Text Searches
Ch 28: Using External Tables
Ch 29: Using Flashback Queries
Ch 30: Flashback—Tables and Databases
Ch 31: SQL Replay
Ch 32: An Introduction to PL/SQL
Ch 33: Online Application Upgrades
Ch 34: Triggers
Ch 35: Procedures, Functions, and Packages
Ch 36: Using Native Dynamic SQL and DBMS_SQL
Ch 37: PL/SQL Tuning
PART V: Object-Relational Databases
Ch 38: Implementing Types, Object Views, and Methods
Ch 39: Collectors (Nested Tables and Varying Arrays)
Ch 40: Using Large Objects
Ch 41: Advanced Object-Oriented Concepts
PART VI: Java in Oracle
Ch 42: An Introduction to Java
Ch 43: JDBC Programming
Ch 44: Java Stored Procedures
PART VII: Hitchhiker's Guides
Ch 45: The Hitchhiker's Guide to Oracle Data Dictionary
Ch 46: The Hitchhiker's Guide to Tuning Applications and SQL
Ch 47: SQL Result Cache and Client-Side Query Cache
Ch 48: Case Studies in Tuning
Ch 49: Advanced Architecture Options--DB Vault, Content DB, and Records DB
Ch 50: Oracle Real Application Clusters
Ch 51: The Hitchhiker’s Guide to Database Administration
Ch 52: The Hitchhiker’s Guide to XML in Oracle
Part VIII Alphabetical Reference

Read More Show Less

Customer Reviews

Average Rating 4.5
( 2 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Posted January 4, 2010

    Oracle Definitive Guide to 11g, I would agree as much as any can be.

    This is a good reference guide to help spin up to 11g. I have worked with Oracle since v7 and find Oracle is always a challenge yet, Oracle Press found Mr. Loney to help focus on the new 11g material. This book is clearly written by someone who has made all the mistakes and understand where you need a "heads up" to the pitfalls. It is clear he uses Oracle and not "paper" or instruction level only but hands on.
    I was very impressed with the material on DB upgrades as most references only lightly touch these issues although this book did the follow the same path in referencing you to the Oracle instructions for more detail Mr. Loney gave informative information.
    The Hitchhiker's Guide was helpful as was the explanation using the Data Pump Export's.
    I purchased this book under the "USED" icon yet the seller had listed it as "NEW". This book was in execellent condition and was a "NEW" book.
    I had never bought any book except directly from Oracle Press or from a major book store like B&N, and I would definitely buy a book using the B&N contractor's sales again. B & N, thank you for screening and providing alternative sources with awesome prices. Great results, great tracking of this shipment. I am very happy with this purchase.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Posted May 6, 2009

    A useful reference for beginner to expert

    Since Oracle 7, this is the first book I get with each major release. It has contained the basic concepts, definitions, and syntax for each database version, making this the book to use for learning Oracle. Especially with major upgrades like 11g.

    With Oracle, no single book could actually be a complete reference, but this book serves as a quick reference to get up to speed on database topics, a starting point for detailed analysis. Although it does not drill deep down on most topics, it has enough detail to put features in context and help solve routine problems.

    Also included are "Hitchhiker Guides" to help proceduralize thought and execution. And don't forget the always useful Alphabetical Reference with the abridged syntax map.

    One additon I would like to see is a distinct way to mark what is new in the current database version. This would help DBAs in multi-version shops who use the book as a quick reference and do not want mix syntax.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)