Professional Oracle Programming -- About the Authors -- Acknowledgments -- Contents -- Introduction -- Introduction -- What Does This Book Cover? -- Who Is This Book For? -- What You Need to Use This Book -- How Is This Book Structured? -- The Bigger Picture -- Conventions -- Source Code -- Errata -- p2p.wrox.com -- Chapter 1: Oracle Architecture and Storage -- Architecture -- Data Types -- Summary -- Chapter 2: Using SQL -- The Processing Cycle for SQL Statements -- Performance Considerations -- Summary -- Chapter 3: Handling Multiple Users -- Goals -- Transactions -- Concurrent User Integrity Problems -- Locks -- Contention -- The Oracle Solution -- Implementation Issues -- Summary -- Chapter 4: Database Design Basics -- Database Design Phases -- Database Design Case Study Example -- Normalization -- Defining Additional Entities (Tables) -- Denormalization -- Other Physical Design Options -- Object-Oriented Design Options of Oracle -- Summary -- Chapter 5: Oracle Security -- Security Concepts -- Authentication -- Authorization -- Access Control -- Accountability -- Enterprise Security -- Security Practices -- Summary -- Chapter 6: The Oracle Data Dictionary -- What Is the Data Dictionary? -- Structure of the Oracle Data Dictionary -- The Oracle Data Dictionary During Development -- The Oracle Data Dictionary at Execution Time -- Summary -- Chapter 7: Installing Oracle -- Getting Oracle Software -- Installing Oracle Server Software -- Accessing Your Oracle Database -- Installing Oracle Client Software -- Summary -- Chapter 8: Introduction to SQL -- A Bit of History -- Standards -- SQL Statement Groupings -- Data Definition Language (DDL) -- Data Manipulation Language (DML) -- SQL: Set-Orientated and Nonprocedural -- Summary -- Chapter 9: Extended SQL -- Extended Conditions -- Extended Set Operations -- MERGE -- TRUNCATE -- ROWNUM and Ranking.

Flashback Query -- Returning Data from Write Operations -- Additional Extensions -- Summary -- Chapter 10: Indexes -- Index Basics -- B-Tree Indexes -- Reverse Key Indexes -- Function-Based Indexes -- Domain Indexes -- Bitmap Indexes -- Bitmap Join Index -- Index-Organized Tables -- Index Clusters -- Hash Cluster -- Design and Performance Tips -- Summary -- Chapter 11: Constraints -- Database Integrity Features -- Types of Constraints -- Working with Constraints -- Summary -- Chapter 12: Other Database Structures -- Tablespaces -- Compression -- Partitioning -- Views -- Materialized Views -- Sequences -- Global Temporary Tables -- Recycle Bin -- Synonyms -- Database Links -- Advanced Queuing and Streams -- Objects -- Stored Procedures, Functions, and Triggers -- Accessing Flat Files -- SGA Buffer Pool Assignments -- Workflows -- Workspace Manager -- Summary -- Chapter 13: Functions -- What Is a Function? -- Defining Your Own Functions -- Oracle's Built-In SQL Functions -- Summary -- Chapter 14: Distributed Queries, Transactions, and Databases -- Linking Distributed Oracle Databases -- Distributed Transactions and Two-Phase Commit -- Heterogeneous Services -- Summary -- Chapter 15: PL/SQL Basics -- Code Architecture -- PL/SQL Language -- Implementing Logic -- Creating a PL/SQL Program -- Using PL/SQL Code -- Security -- Native Compilation -- Uses of PL/SQL Units -- Summary -- Chapter 16: PL/SQL and SQL -- Basic SQL in PL/SQL -- Cursors -- Using a Single Cursor -- Special Data Types -- FOR Cursor -- Implicit Cursors -- REF CURSORs -- PL/SQL Records and Collections -- BULK COLLECT -- FORALL -- Dynamic SQL -- Summary -- Chapter 17: PL/SQL Packages -- What Is a Package? -- Impact of Packages -- An Example -- Using Packages Together -- Summary -- Chapter 18: Introduction to Java Database Programming -- Java Architecture -- Oracle's Java Architecture.

Building Sample Applications -- Summary -- Chapter 19: Triggers -- What Are Triggers? -- Working with Triggers -- Special Circumstances -- Triggers in Other Languages -- Triggers and Mutating Tables -- Removing Triggers -- Viewing Triggers in the Data Dictionary -- Limitations of Triggers -- Summary -- Chapter 20: Regular Expressions and Expression Filter -- Regular Expressions -- Expression Filter -- Summary -- Chapter 21: Object Relational Interactions with Oracle -- Object Relational -- Introducing Oracle Objects -- Using Oracle Object Types -- Object Views on Relational Data -- Oracle JPublisher (JPub) -- Summary -- Chapter 22: Oracle XML DB -- Overview of the XML DB Repository -- XMLType -- XML Schema -- SQL/XML and Query Rewrite -- SQL to XML -- Transforming XML -- A Content Management Example -- Summary -- Chapter 23: HTML-DB -- What Is HTML-DB? -- The HTML-DB Environment -- Installing HTML-DB -- Preparing a Development Environment -- Importing Data -- Creating an Application -- Functionality in Your HTML-DB Application -- Adding a New Page -- Modifying Page Attributes -- Running the Application -- Is That All There Is? -- The Next Step -- Summary -- Chapter 24: High-Speed Data Movement -- Export/Import and the "Data Pump" -- Transportable Tablespaces -- Streams -- Summary -- Chapter 25: Data Loading and Management -- SQL* Loader -- External Table Database Feature -- Transformations -- Change Data Capture -- Partitioning and the Speed of ETL -- Oracle Warehouse Builder -- Summary -- Chapter 26: Business Intelligence Query -- Schema for Business Intelligence -- Summary Tables and Materialized Views -- Aggregation through SQL: Rollup and Cube -- Proactive Management of Complex Query Workloads -- Summary -- Chapter 27: Business Intelligence Analysis -- SQL Analytics and Statistics -- OLAP -- Data Mining -- Summary -- Chapter 28: Optimization.

What Is Optimization? -- The Oracle Optimizer -- Optimizer Modes -- Statistics -- Execution Plans -- Execution Statistics -- Viewing Execution Plans and Statistics -- Hints -- Stored Outlines -- Summary -- Index.