Oracle 11G

Oracle 11g Complete reference

Kevin Loney "Oracle Database 11g The Complete Reference"
2009 | English | ISBN : 978-0-07-159875-0 | 1369 Pages | PDF | 5.72 MB

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 ***s
* 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

Download