作者:Kevin Loney
出版日期:December 17, 2008
出版社:McGraw-Hill
页数:1368
ISBN:ISBN-10: 0071598758 ISBN-13: 978-0071598750
文件格式:PDF
Product Description
The Definitive Guide to Oracle Database 11gGet full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explainshow to use all the new features and tools, execute powerful SQLqueries, construct PL/SQL and SQL*Plus statements, and work with largeobjects and object-relational databases. Learn how to implement thelatest security measures, tune database performance, and deploy gridcomputing techniques. An invaluable cross-referenced appendixcontaining Oracle commands, keywords, features, and functions is alsoincluded.
Install Oracle Database 11g or upgrade from an earlier versionCreate 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 the Author
Kevin Loney was named Consultant ofthe Year by ORACLE Magazine in2002. He is an internationally recognized Oracle expert who frequentlypresents at Oracle user conferences in North America and Europe wherehe is regularly among the highest-rated presenters.