Oracle Database 10g Complete Reference Manual

Author: Long Li (USA)
Publisher:
Publish Date: 2006-09-01
Features: This book comprehensively and systematically introduces all features of Oracle Database 10g, delves into the details of these new features, outlines the database architecture and Oracle grid computing technology, covers SQL, SQL/Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java programming in the Oracle environment. The book also includes valuable database management and application development techniques, as well as a command and terminology reference (including major Oracle commands, keywords, features, and functions, as well as cross-references for each topic).... This book comprehensively and systematically introduces all features of Oracle Database 10g, delves into the details of these new features, outlines the database architecture and Oracle grid computing technology, covers SQL, SQL/Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java programming in the Oracle environment. The book also includes valuable database management and application development techniques, as well as a command and terminology reference (including major Oracle commands, keywords, features, and functions, as well as cross-references for each topic). Main contents of the book: Installing Oracle Database 10g or upgrading from earlier versions; executing SQL queries; performing complex searches using regular expression functions; implementing security measures using VPD (Virtual Private Databases); moving data using SQLLoader and Data Pump; storing data copies using materialized views; performing flashback queries to recover data or view data changes over time; creating triggers, stored procedures, and packages using PL/SQL; developing applications using JDBC and MXL; using Oracle Database 10 Real Application Clusters (RAC) and grid technology; leveraging new tuning features.