The Definitive Guide to Oracle Database 11g

Get full details on the powerful features of Oracle Database 11g 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 11g 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 Cluste