Oracle Database 11g The Complete Reference, 1/e

Oracle Database 11g The Complete Reference, 1/e (Paperback)

By Kevin Loney 
Publisher: Tata McGraw-Hill
Edition: Paperback
Edition Number: 1
Language: English
ISBN: 0070140790
EAN: 9780070140790
Publish Date: 2008
Binding: Paperback
Ships to India.



The Definitive Guide to Oracle Database 11

Get full details on the powerful features of Oracle Database 11

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 11

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 11

Architecture Options

Ch 2: Installing Oracle Database 11

and Creating a Database

Ch 3: Upgrading to Oracle Database 11

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


Alphabetical Reference


show moreless


Title: Oracle Database 11g The Complete Reference, 1/e
Publisher: Tata McGraw-Hill
Author: Kevin Loney
Edition: Paperback
Edition Number: 1
Language: English
ISBN: 0070140790
EAN: 9780070140790
Publish Date: 2008
Binding: Paperback


  • 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.
  • For the imported title, once the order gets placed ,it can’t be cancelled

Great Value

Safe Payment

Shop With

24/7 Help Center

Free & Easy Return

Get Discounts & Offers
Stay Connected

Popular Searches on

Online Shopping: Deal of The Day / Hot Deals / Best Deals / Offers

Apple iPhones: Iphone Xs Max / Iphone Xs / Iphone XR / iPhone 8 / iPhone 8 / iPhone 7 / iPhone 7 Plus / iPhone 6s / iPhone 5s

Mobile Phones:Unboxed Mobiles / Apple Mobiles / Samsung Mobiles / Micromax Mobiles / Sony Mobiles / Intex Mobiles / Latest Mobiles / Smartphones / 4G Phones / 3G Phones

Computers:Dell Laptops / Lenovo Laptops / Acer Laptops / HP Laptops / External Hard Disks / Pen Drives / Monitors / Softwares / Printers

Appliances:Air Conditioners / Air Coolers / Refrigerators / Geysers / Room Heaters / Immersion Rod / Water Purifiers / Washing Machines / Microwaves & OTG / Air Purifier

Electronics: Tablets / Cameras / Headphones / Power Bank / LED TVs / Gaming Consoles / Speakers / Tablet Accessories / Memory Cards

Men's Clothing: Shirts / T-Shirts / Tracksuits / Trousers / Ethnic Wear / Men's Denim / Cargo Shorts / Tees & Polos / Suits & Blazer

Women's Clothing: Dress Materials / Salwar Suits / Women Sarees / Kurtas & Kurtis / Leggings / Lingerie / Night Suits & Nighties / Women Shorts / Tops

Fashion:Men's Shoes / Women's Footwear / Fastrack Watches / Titan Watches / Timex Watches / Bags / Jewellery / Fastrack Sunglasses / Perfumes & Deodorants / Fashion Accessories

Buy Books Online:Best Sellers Books / Business Books / History and Politics / Academic and Professional / Competitive Exams / Biographies and Autobiographies

Best Ecommerce Platform:Online Store Builder / Create Online Store / Best Ecommerce Solutions / Sell Online / Ecommerce Marketing Blog

Ecommerce Website Templates:Free Website Templates / Free Logo Design / SEO Audit Report / Theme Store / Wordpress Themes / Web & App Development Company

Copyright © 2007-2019 and Affiliates
Site is up