BN.com Gift Guide

Oracle Database 11g The Complete Reference / Edition 1

Hardcover (Print)
Rent
Rent from BN.com
$20.06
(Save 75%)
Est. Return Date: 02/15/2015
Buy Used
Buy Used from BN.com
$46.47
Used and New from Other Sellers
Used and New from Other Sellers
from $18.07
Usually ships in 1-2 business days
(Save 77%)
Other sellers (Hardcover)
  • All (15) from $18.07   
  • New (5) from $43.01   
  • Used (10) from $18.07   
Close
Sort by
Page 1 of 2
Showing 1 – 10 of 15 (2 pages)
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$18.07
Seller since 2009

Feedback rating:

(1841)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Good
2009 Hardcover Good Books have varying amounts of wear and highlighting. Usually ships within 24 hours in quality packaging. Satisfaction guaranteed. This item may not include ... any CDs, Infotracs, Access cards or other supplementary material. Read more Show Less

Ships from: Lincoln, NE

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$18.09
Seller since 2014

Feedback rating:

(35)

Condition: Good
2008 Hardcover Good 073 Item may show signs of shelf wear. Pages may include limited notes and highlighting. Includes supplemental or companion materials if applicable. Access ... codes may or may not work. Connecting readers since 1972. Customer service is our top priority. Read more Show Less

Ships from: Dallas, TX

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$19.86
Seller since 2005

Feedback rating:

(623)

Condition: Good
2009 Hardcover Good Condition. Reasonable wear. Still very usable. Clean, mark-free interior! SHIPS W/IN 24 HOURS! Processed by DHL with USPS delivery for an average of 3-5 Day ... Standard Shipping & 2-3 Day Expedited Shipping! ! FREE INSURANCE! Fast & Personal Support! Careful Packaging. No Hassle, Full Refund Return Policy! Read more Show Less

Ships from: Alton, IL

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$21.31
Seller since 2006

Feedback rating:

(60901)

Condition: Acceptable
Former Library book. Shows definite wear, and perhaps considerable marking on inside. 100% Money Back Guarantee. Shipped to over one million happy customers. Your purchase ... benefits world literacy! Read more Show Less

Ships from: Mishawaka, IN

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$30.34
Seller since 2009

Feedback rating:

(10631)

Condition: Good
Used - Very Good Book. Shipped from US within 4 to 14 business days. Established seller since 2000

Ships from: Secaucus, NJ

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$30.80
Seller since 2008

Feedback rating:

(17845)

Condition: Acceptable
Used, Acceptable Condition, may show signs of wear and previous use. Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: Westminster, MD

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$35.00
Seller since 2005

Feedback rating:

(186)

Condition: Very Good
Hardcover Very Good 0071598758 Boards mildly edgeworn. Binding sound. Interior bright and unmarked.

Ships from: Salem, OR

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$37.00
Seller since 2009

Feedback rating:

(166)

Condition: Very Good
N/a N/a 2009 Hard Cover N/a Very Good 8vo. No writing, highlighting or creases. Spine feels a bit wobbly but binding is tight. Cover has scratches/scuffs & small corner bumps. ... [#56477] Read more Show Less

Ships from: Jacksonville, FL

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$43.01
Seller since 2008

Feedback rating:

(17845)

Condition: New
Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: Westminster, MD

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$43.02
Seller since 2008

Feedback rating:

(4531)

Condition: New
New Book. Shipped from UK within 4 to 14 business days. Established seller since 2000.

Ships from: Horcott Rd, Fairford, United Kingdom

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 2
Showing 1 – 10 of 15 (2 pages)
Close
Sort by

Overview

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: 466,156
  • 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
PART II: SQL and SQL*Plus
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
PART IV: PL/SQL
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
Index

Read More Show Less

Customer Reviews

Average Rating 4.5
( 2 )
Rating Distribution

5 Star

(1)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com 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 & Noble.com 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 & Noble.com 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 BN.com 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

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com 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 BN.com. 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)