Oracle Database 11g The Complete Reference (Oracle Press) - Hardcover

Loney, Kevin

Hardcover

ISBN 10: 0071598758 ISBN 13: 9780071598750

Publisher: McGraw Hill, 2009

Synopsis

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

About this title

About the Author:

Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine

About this edition

• Publisher: McGraw Hill
• Publication date: 2009
• ISBN 10: 0071598758
• ISBN 13: 9780071598750
• Binding: Hardcover
• Number of pages: 1368