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 Clusters
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.
Keywords: ORACLE DATABASE 11G, HOW TO USE ORACLE DATABASE 11G, ORACLE PRESS, ORACLE DBA, ORACLE DEVELOPER, ORACLE GRID COMPUTING, PL/SQL, DATABASE TABLES, SQL STATEMENTS, SQL QUERIES, VIRTUAL PRIVATE DATABASE, TRANSPARENT DATA ENCRYPTION, SQL*LOADER, ORACLE DATA PUMP, SQL REPLAY, FLASHBACK, AUTOMATIC UNDO, PL/SQL, JAVA, JDBC, XML, ORACLE REAL APPLICATION CLUSTERS, ORACLE DATABASE 11G NEW FEATURES, ORACLE DATABASE 11G: A BEGINNER'S GUIDE, ORACLE DATABASE 11G SQL, ORACLE DATABASE 11G PL/SQL PROGRAMMING, ORACLE DATABASE 11G DBA HANDBOOK, OCA ORACLE DATABASE 11G ADMINISTRATION I EXAM GUIDE, OCA ORACLE DATABASE 11G SQL FUNDAMENTALS I EXAM GUIDE, OCP ORACLE DATABASE 11G NEW FEATURES FOR ADMINISTRATORS EXAM GUIDE, OCP ORACLE DATABASE 11G ADMINISTRATION II EXAM GUIDE,