9780071598750

The Definitive Guide to Oracle Database 11 gGet full details on the powerful features of Oracle Database 11 g 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 g 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

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.

Critical Database Concepts
Oracle Database 11gArchitecture Options
Installing Oracle Database 11gand Creating a Database
Upgrading to Oracle Database 11g
Planning Oracle Applicationsn++Approaches, Risks, and Standards
SQL and SQL*Plus
The Basic Parts of Speech in SQL
Basic SQL*Plus Reports and Commands
Getting Text Information and Changing It
Searching for Regular Expressions
Playing the Numbers
Dates: Then, Now, and the Difference
Conversion and Transformation Functions
Grouping Things Together
When One Query Depends upon Another
Some Complex Possibilities
Changing Data: insert, update, merge, and delete
DECODE and CASE: if, then, and else in SQL
Creating and Managing Tables, Views, Indexes, Clusters, and Sequences
Partitioning
Basic Oracle Security
Beyond the Basics
Advanced Securityn++Virtual Private Databases
Advanced Security: Transparent Data Encryption
Working with Tablespaces
Using SQL*Loader to Load Data
Using Data Pump Export and Import
Accessing Remote Data
Using Materialized Views
Using Oracle Text for Text Searches
Using External Tables
Using Flashback Queries
Flashbackn++Tables and Databases
SQL Replay
PL/SQL
An Introduction to PL/SQL
Online Application Upgrades
Triggers
Procedures, Functions, and Packages
Using Native Dynamic SQL and DBMS_SQL
PL/SQL Tuning
Object-Relational Databases
Implementing Types, Object Views, and Methods
Collectors (Nested Tables and Varying Arrays)
Using Large Objects
Advanced Object-Oriented Concepts
Java in Oracle
An Introduction to Java
JDBC Programming
Java Stored Procedures
Hitchhiker's Guides
The Hitchhiker's Guide to Oracle Data Dictionary
The Hitchhiker's Guide to Tuning Applications and SQL
SQL Result Cache and Client-Side Query Cache
Case Studies in Tuning
Advanced Architecture Options--DB Vault, Content DB, and Records DB
Oracle Real Application Clusters
The Hitchhikern++s Guide to Database Administration
The Hitchhikern++s Guide to XML in Oracle
Alphabetical
Reference
Index
Table of Contents provided by Publisher. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Oracle Database 11G The Complete Reference

Oracle Database 11G The Complete Reference

0071598758

Summary

Author Biography

Table of Contents

Supplemental Materials