Oracle Database 11G The Complete Reference

by Loney

• ISBN13: 9780071598750
• ISBN10: 0071598758
• Edition: 1st
• Format: Hardcover
• Copyright: 2009-01-07
• Publisher: McGraw-Hill Education

Summary

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

Author Biography

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.

Table of Contents

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.