Oracle Database 11g: The Complete Reference

0.0

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 The Author Kevin Loney was named Consultant of the 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. Table of Contents PART I: Critical Database Concepts Chapter 1: Oracle Database 11g ArChapteritecture Options Chapter 2: Installing Oracle Database 11g and Creating a Database Chapter 3: Upgrading to Oracle Database 11g Chapter 4: Planning Oracle Applications-ApproaChapteres, Risks, and Standards PART II: SQL and SQL*Plus Chapter 5: The Basic Parts of SpeeChapter in SQL Chapter 6: Basic SQL*Plus Reports and Commands Chapter 7: Getting Text Information and Chapteranging It Chapter 8: SearChaptering for Regular Expressions Chapter 9: Playing the Numbers Chapter 10: Dates: Then, Now, and the Difference Chapter 11: Conversion and Transformation Functions Chapter 12: Grouping Things Together Chapter 13: When One Query Depends upon Another Chapter 14: Some Complex Possibilities Chapter 15: Chapteranging Data: insert, update, merge, and delete Chapter 16: DECODE and CASE: if, then, and else in SQL Chapter 17: Creating and Managing Tables, Views, Indexes, Clusters, and Sequences Chapter 18: Partitioning Chapter 19: Basic Oracle Security PART III: Beyond the Basics Chapter 20: Advanced Security-Virtual Private Databases Chapter 21: Advanced Security: Transparent Data Encryption Chapter 22: Working with Tablespaces Chapter 23: Using SQL*Loader to Load Data Chapter 24: Using Data Pump Export and Import Chapter 25: Accessing Remote Data Chapter 26: Using Materialized Views Chapter 27: Using Oracle Text for Text SearChapteres Chapter 28: Using External Tables Chapter 29: Using Flashback Queries Chapter 30: Flashback-Tables and Databases Chapter 31: SQL Replay PART IV: PL/SQL Chapter 32: An Introduction to PL/SQL Chapter 33: Online Application Upgrades Chapter 34: Triggers Chapter 35: Procedures, Functions, and Packages Chapter 36: Using Native Dynamic SQL and DBMS_SQL Chapter 37: PL/SQL Tuning PART V: Object-Relational Databases Chapter 38: Implementing Types, Object Views, and Methods Chapter 39: Collectors (Nested Tables and Varying Arrays) Chapter 40: Using Large Objects Chapter 41: Advanced Object-Oriented Concepts PART VI: Java in Oracle Chapter 42: An Introduction to Java Chapter 43: JDBC Programming Chapter 44: Java Stored Procedures PART VII: Hitchhiker's Guides Chapter 45: The Hitchhiker's Guide to Oracle Data Dictionary Chapter 46: The Hitchhiker's Guide to Tuning Applications and SQL Chapter 47: SQL Result CaChaptere and Client-Side Query CaChaptere Chapter 48: Case Studies in Tuning Chapter 49: Advanced ArChapteritecture Options--DB Vault, Content DB, and Records DB Chapter 50: Oracle Real Application Clusters Chapter 51: The Hitchhiker's Guide to Database Administration Chapter 52: The Hitchhiker's Guide to XML in Oracle Part VIII Alphabetical Reference Index