Oracle Database 10g Complete Reference Manual

Author: Long Li
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 term 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 term reference (including major Oracle commands, keywords, features, and functions, as well as cross-references for each topic). Main Content of the Book · Installing Oracle Database 10g or upgrading from earlier versions · Executing seL queries · Performing complex searches using regular expression functions · Implementing security measures with VPD (Virtual Private Databases) · Moving data using SQLLoader and Data Pump · Storing data replicas with materialized views · Executing flashback queries to restore data or view data changes over time · Creating triggers, stored procedures, and packages with PL/SQL · Developing applications using JDBC and XML · Utilizing Oracle Database 10g Real Application Clusters (RAC) and grid technology · Leveraging new tuning features