Oracle Database 11g The Complete Reference / Edition 1

Oracle Database 11g The Complete Reference / Edition 1

4.5 2
by Kevin Loney

View All Available Formats & Editions

ISBN-10: 0071598758

ISBN-13: 9780071598750

Pub. Date: 12/17/2008

Publisher: McGraw-Hill Professional Publishing

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


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

Product Details

McGraw-Hill Professional Publishing
Publication date:
Oracle Press Series
Product dimensions:
7.50(w) x 9.20(h) x 2.10(d)

Related Subjects

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

Customer Reviews

Average Review:

Write a Review

and post it to your social network


Most Helpful Customer Reviews

See all customer reviews >

Oracle Database 11g The Complete Reference 4.5 out of 5 based on 0 ratings. 2 reviews.
dba_n_the_dark More than 1 year ago
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.
Bob_Z More than 1 year ago
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.