Oracle Database 10g Complete Reference Manual

Author: Zhang Lihao
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. It also includes valuable database management and application development techniques, as well as a command and term reference (which includes major Oracle commands, keywords, features, and functions, as well as cross-references for each topic). The main content of the book includes:
- 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 with SQLLoader and Data Pump
- Using materialized views to store data copies
- Performing flashback queries to recover data or view data changes over time
- Creating triggers, stored procedures, and packages with PL/SQL
- Developing applications with JDBC and MXL
- Using Oracle Database 10g Real Application Clusters (RAC) and grid technology
- Leveraging new tuning features.