Oracle Database 11g The Complete Reference (Oracle Press)

Oracle Database 11g The Complete Reference (Oracle Press)

<p><strong>The Definitive Guide to Oracle Database 11<em>g</em></strong></p><p>Get full details on the powerful features of Oracle Database 11<em>g</em> from this thoroughly updated Oracle Press guide. <em>Oracle Database 11g: The Complete Reference </em>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.</p><ul><li>Install Oracle Database 11<em>g</em> or upgrade from an earlier version</li><li><div>Create database tables, sequences, indexes, views, and user accounts</div></li><li><div>Construct SQL statements, procedures, queries, and subqueries </div></li><li><div>Optimize security using virtual private databases and transparent data encryption</div></li><li><div>Import and export data using SQL*Loader and Oracle Data Pump </div></li><li><div>Use SQL replay, change management, and result caching</div></li><li><div>Avoid human errors using flashback and automatic undo management</div></li><li><div>Build and tune PL/SQL triggers, functions, and packages</div></li><li><div>Develop database applications using Java, JDBC, and XML</div></li><li><div>Optimize availability and scalability with Oracle Real Application Clusters</div></li></ul>