| |
| |
| |
| Critical Database Concepts | |
| |
| |
| |
| Oracle Database 11gArchitecture Options | |
| |
| |
| |
| Installing Oracle Database 11gand Creating a Database | |
| |
| |
| |
| Upgrading to Oracle Database 11g | |
| |
| |
| |
| Planning Oracle Applicationsn++Approaches, Risks, and Standards | |
| |
| |
| |
| SQL and SQL*Plus | |
| |
| |
| |
| The Basic Parts of Speech in SQL | |
| |
| |
| |
| Basic SQL*Plus Reports and Commands | |
| |
| |
| |
| Getting Text Information and Changing It | |
| |
| |
| |
| Searching for Regular Expressions | |
| |
| |
| |
| Playing the Numbers | |
| |
| |
| |
| Dates: Then, Now, and the Difference | |
| |
| |
| |
| Conversion and Transformation Functions | |
| |
| |
| |
| Grouping Things Together | |
| |
| |
| |
| When One Query Depends upon Another | |
| |
| |
| |
| Some Complex Possibilities | |
| |
| |
| |
| Changing Data: insert, update, merge, and delete | |
| |
| |
| |
| DECODE and CASE: if, then, and else in SQL | |
| |
| |
| |
| Creating and Managing Tables, Views, Indexes, Clusters, and Sequences | |
| |
| |
| |
| Partitioning | |
| |
| |
| |
| Basic Oracle Security | |
| |
| |
| |
| Beyond the Basics | |
| |
| |
| |
| Advanced Securityn++Virtual Private Databases | |
| |
| |
| |
| Advanced Security: Transparent Data Encryption | |
| |
| |
| |
| Working with Tablespaces | |
| |
| |
| |
| Using SQL*Loader to Load Data | |
| |
| |
| |
| Using Data Pump Export and Import | |
| |
| |
| |
| Accessing Remote Data | |
| |
| |
| |
| Using Materialized Views | |
| |
| |
| |
| Using Oracle Text for Text Searches | |
| |
| |
| |
| Using External Tables | |
| |
| |
| |
| Using Flashback Queries | |
| |
| |
| |
| Flashbackn++Tables and Databases | |
| |
| |
| |
| SQL Replay | |
| |
| |
| |
| PL/SQL | |
| |
| |
| |
| An Introduction to PL/SQL | |
| |
| |
| |
| Online Application Upgrades | |
| |
| |
| |
| Triggers | |
| |
| |
| |
| Procedures, Functions, and Packages | |
| |
| |
| |
| Using Native Dynamic SQL and DBMS_SQL | |
| |
| |
| |
| PL/SQL Tuning | |
| |
| |
| |
| Object-Relational Databases | |
| |
| |
| |
| Implementing Types, Object Views, and Methods | |
| |
| |
| |
| Collectors (Nested Tables and Varying Arrays) | |
| |
| |
| |
| Using Large Objects | |
| |
| |
| |
| Advanced Object-Oriented Concepts | |
| |
| |
| |
| Java in Oracle | |
| |
| |
| |
| An Introduction to Java | |
| |
| |
| |
| JDBC Programming | |
| |
| |
| |
| Java Stored Procedures | |
| |
| |
| |
| Hitchhiker's Guides | |
| |
| |
| |
| The Hitchhiker's Guide to Oracle Data Dictionary | |
| |
| |
| |
| The Hitchhiker's Guide to Tuning Applications and SQL | |
| |
| |
| |
| SQL Result Cache and Client-Side Query Cache | |
| |
| |
| |
| Case Studies in Tuning | |
| |
| |
| |
| Advanced Architecture Options--DB Vault, Content DB, and Records DB | |
| |
| |
| |
| Oracle Real Application Clusters | |
| |
| |
| |
| The Hitchhikern++s Guide to Database Administration | |
| |
| |
| |
| The Hitchhikern++s Guide to XML in Oracle | |
| |
| |
| |
| Alphabetical | |
| |
| |
| Reference | |
| |
| |
| Index | |