Sign in  |  Register
Advanced search
Publication Cover

CITATION

Loney, Kevin. Oracle Database 11g The Complete Reference. US: McGraw-Hill Osborne Media, 2008.

Oracle Database 11g The Complete Reference

Authors: Kevin Loney

Published:  December 2008

eISBN: 9780071598767 0071598766 | ISBN: 9780071598750
Open eBook

Book description:

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,