Oracle Database 11g The Complete Reference

Oracle Database 11g The Complete Reference ( PDF eBook - Adobe PDF ) (eBook)

By Kevin Loney 
Publisher: McGraw-Hill Professional
Edition: PDF
Edition: eBook , PDF
Language: English
ISBN: 0071598758-BEPDF
EAN: 9780071598750-BEPDF
Publish Date: 2008-12-17
Binding: eBook
 System Requirements for Adobe-DRM eBooks

Other Editions

Edition Price Availability
Paperback 2008, 1st Edition R 740 In Stock.
Ebook 2008 R 4,142 In Stock.
Ebook 2008 R 4,142 In Stock.
Hardcover 2009 R 5,050 In Stock.


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

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 VIIIAlphabetical Reference


show moreless


Title: Oracle Database 11g The Complete Reference
Publisher: McGraw-Hill Professional
Author: Kevin Loney
Edition: PDF
Edition: eBook , PDF
Language: English
ISBN: 0071598758-BEPDF
EAN: 9780071598750-BEPDF
Publish Date: 2008-12-17
Binding: eBook


  • The book summary and image may be of a different edition or binding of the same title.
  • Book reviews are added by registered customers. They need not necessarily buy book.
  • These books are NOT available for reading online or for free download in PDF or ebook format.
  • Price can change due to reprinting, price change by publisher or sourcing cost change for imported books.
  • is the biggest online bookstore in India for sale of books at best price - fiction, literature, audiobooks, study guides, novels, story books, rare books, textbooks and books by popular authors. These are available in various editions and bindings e.g. paperback and at best discount.