Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Start ReadingShareBuy Print Version
    Oracle Database 10g: The Complete Reference

    • Oracle Database 10g: The Complete Reference

    • By:

    • Publisher: Oracle Press

    • Pub. Date:

    • Print ISBN: 978-0-0722-5351-1

    • Web ISBN: 0-07-225351-7

    • Pages in Print Edition: 1200

    • Subscriber Rating: 0 out of 5 rating0 [0 Ratings]

    ebooken
    Subscriber Reviews • Browse Similar Topics

    Overview

    Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

    Subscriber Reviews

    Average Rating: 0 out of 5 rating Based on 0 Ratings

    No Subscribers have provided a review for this book.

    Table of Contents

     Index

    View Sample

    Copyright

    View Sample

    Dedication

    View Sample

    About the Author

    View Sample

    Acknowledgments

    View Sample

    Introduction

    View Sample

    Part 1: Critical Database Concepts

    View Sample
    Chapter 1. Oracle Database 10g Architecture Options
    View Sample

    Section 1.1. Databases and Instances

    View Sample

    Section 1.2. Inside the Database

    View Sample

    Section 1.3. Choosing Architectures and Options

    View Sample
    Chapter 2. Installing Oracle Database 10g and Creating a Database
    View Sample

    Section 2.1. Overview of Licensing and Installation Options

    View Sample
    Chapter 3. Upgrading to Oracle Database 10g
    View Sample

    Section 3.1. Choosing an Upgrade Method

    View Sample

    Section 3.2. Before Upgrading

    View Sample

    Section 3.3. Using the Database Upgrade Assistant

    View Sample

    Section 3.4. Performing a Manual Direct Upgrade

    View Sample

    Section 3.5. Using Export and Import

    View Sample

    Section 3.6. Using the Data-Copying Method

    View Sample

    Section 3.7. After Upgrading

    View Sample
    Chapter 4. Planning Oracle Applications—Approaches, Risks, and Standards
    View Sample

    Section 4.1. The Cooperative Approach

    View Sample

    Section 4.2. Everyone Has "Data"

    View Sample

    Section 4.3. The Familiar Language of Oracle

    View Sample

    Section 4.4. Some Common, Everyday Examples

    View Sample

    Section 4.5. What Are the Risks?

    View Sample

    Section 4.6. The Importance of the New Vision

    View Sample

    Section 4.7. How to Reduce the Confusion

    View Sample

    Section 4.8. Capitalization in Names and Data

    View Sample

    Section 4.9. Normalizing Names

    View Sample

    Section 4.10. Good Design Has a Human Touch

    View Sample

    Section 4.11. Understanding the Data

    View Sample

    Section 4.12. Toward Object Name Normalization

    View Sample

    Section 4.13. Intelligent Keys and Column Values

    View Sample

    Section 4.14. The Commandments

    View Sample

    Part 2: SQL and SQL*Plus

    View Sample
    Chapter 5. The Basic Parts of Speech in SQL
    View Sample

    Section 5.1. Style

    View Sample

    Section 5.2. Creating the NEWSPAPER Table

    View Sample

    Section 5.3. Using SQL to Select Data from Tables

    View Sample

    Section 5.4. select, from, where, and order by

    View Sample

    Section 5.5. Logic and Value

    View Sample

    Section 5.6. Another Use for where: Subqueries

    View Sample

    Section 5.7. Combining Tables

    View Sample

    Section 5.8. Creating a View

    View Sample
    Chapter 6. Basic SQL*Plus Reports and Commands
    View Sample

    Section 6.1. Building a Simple Report

    View Sample

    Section 6.2. Other Features

    View Sample

    Section 6.3. Checking the SQL*Plus Environment

    View Sample

    Section 6.4. Building Blocks

    View Sample
    Chapter 7. Getting Text Information and Changing It
    View Sample

    Section 7.1. Datatypes

    View Sample

    Section 7.2. What Is a String?

    View Sample

    Section 7.3. Notation

    View Sample

    Section 7.4. Concatenation ( || )

    View Sample

    Section 7.5. How to Cut and Paste Strings

    View Sample

    Section 7.6. Using order by and where with String Functions

    View Sample

    Section 7.7. Review

    View Sample
    Chapter 8. Searching for Regular Expressions
    View Sample

    Section 8.1. Search Strings

    View Sample

    Section 8.2. REGEXP_SUBSTR

    View Sample
    Chapter 9. Playing the Numbers
    View Sample

    Section 9.1. The Three Classes of Number Functions

    View Sample

    Section 9.2. Notation

    View Sample

    Section 9.3. Single-Value Functions

    View Sample

    Section 9.4. Aggregate Functions

    View Sample

    Section 9.5. List Functions

    View Sample

    Section 9.6. Finding Rows with MAX or MIN

    View Sample

    Section 9.7. Precedence and Parentheses

    View Sample

    Section 9.8. Review

    View Sample
    Chapter 10. Dates: Then, Now, and the Difference
    View Sample

    Section 10.1. Date Arithmetic

    View Sample

    Section 10.2. ROUND and TRUNC in Date Calculations

    View Sample

    Section 10.3. TO_DATE and TO_CHAR Formatting

    View Sample

    Section 10.4. Dates in where Clauses

    View Sample

    Section 10.5. Dealing with Multiple Centuries

    View Sample

    Section 10.6. Using the EXTRACT Function

    View Sample

    Section 10.7. Using the TIMESTAMP Datatypes

    View Sample
    Chapter 11. Conversion and Transformation Functions
    View Sample

    Section 11.1. Elementary Conversion Functions

    View Sample

    Section 11.2. Specialized Conversion Functions

    View Sample

    Section 11.3. Transformation Functions

    View Sample

    Section 11.4. Review

    View Sample
    Chapter 12. Grouping Things Together
    View Sample

    Section 12.1. The Use of group by and having

    View Sample

    Section 12.2. Views of Groups

    View Sample

    Section 12.3. The Power of Views of Groups

    View Sample

    Section 12.4. More Grouping Possibilities

    View Sample
    Chapter 13. When One Query Depends upon Another
    View Sample

    Section 13.1. Advanced Subqueries

    View Sample

    Section 13.2. Outer Joins

    View Sample

    Section 13.3. Natural and Inner Joins

    View Sample

    Section 13.4. UNION, INTERSECT, and MINUS

    View Sample
    Chapter 14. Some Complex Possibilities
    View Sample

    Section 14.1. Complex Groupings

    View Sample

    Section 14.2. Using Temporary Tables

    View Sample

    Section 14.3. Using ROLLUP, GROUPING, and CUBE

    View Sample

    Section 14.4. Family Trees and connect by

    View Sample
    Chapter 15. Changing Data: insert, update, merge, and delete
    View Sample

    Section 15.1. insert

    View Sample

    Section 15.2. rollback, commit, and autocommit

    View Sample

    Section 15.3. Multitable Inserts

    View Sample

    Section 15.4. delete

    View Sample

    Section 15.5. update

    View Sample

    Section 15.6. Using the merge Command

    View Sample
    Chapter 16. DECODE and CASE: if, then, and else in SQL
    View Sample

    Section 16.1. if, then, else

    View Sample

    Section 16.2. Replacing Values via DECODE

    View Sample

    Section 16.3. DECODE Within DECODE

    View Sample

    Section 16.4. Greater Than and Less Than in DECODE

    View Sample

    Section 16.5. Using CASE

    View Sample
    Chapter 17. Creating and Managing Tables, Views, Indexes, Clusters, and Sequences.
    View Sample

    Section 17.1. Creating a Table

    View Sample

    Section 17.2. Dropping Tables

    View Sample

    Section 17.3. Altering Tables

    View Sample

    Section 17.4. Creating a Table from a Table

    View Sample

    Section 17.5. Creating an Index-Organized Table

    View Sample

    Section 17.6. Using Partitioned Tables

    View Sample

    Section 17.7. Creating a View

    View Sample

    Section 17.8. Indexes

    View Sample

    Section 17.9. Clusters

    View Sample

    Section 17.10. Sequences

    View Sample
    Chapter 18. Basic Oracle Security
    View Sample

    Section 18.1. Users, Roles, and Privileges

    View Sample

    Section 18.2. What Users Can Grant

    View Sample

    Section 18.3. Granting Limited Resources

    View Sample

    Part 3: Beyond the Basics

    View Sample
    Chapter 19. Advanced Security—Virtual Private Databases
    View Sample

    Section 19.1. Initial Configuration

    View Sample

    Section 19.2. Create an Application Context

    View Sample

    Section 19.3. Create a Logon Trigger

    View Sample

    Section 19.4. Create a Security Policy

    View Sample

    Section 19.5. Apply the Security Policy to Tables

    View Sample

    Section 19.6. Test VPD

    View Sample

    Section 19.7. How to Implement Column-Level VPD

    View Sample

    Section 19.8. How to Disable VPD

    View Sample

    Section 19.9. How to Use Policy Groups

    View Sample
    Chapter 20. Working with Tablespaces
    View Sample

    Section 20.1. Tablespaces and the Structure of the Database

    View Sample

    Section 20.2. Planning Your Tablespace Usage

    View Sample
    Chapter 21. Using SQL*Loader to Load Data
    View Sample

    Section 21.1. The Control File

    View Sample

    Section 21.2. Starting the Load

    View Sample

    Section 21.3. Control File Syntax Notes

    View Sample

    Section 21.4. Managing Data Loads

    View Sample

    Section 21.5. Tuning Data Loads

    View Sample

    Section 21.6. Additional Features

    View Sample
    Chapter 22. Using Date Pump Export and Import
    View Sample

    Section 22.1. Creating a Directory

    View Sample

    Section 22.2. Data Pump Export Options

    View Sample

    Section 22.3. Starting a Data Pump Export Job

    View Sample

    Section 22.4. Data Pump Import Options

    View Sample

    Section 22.5. Starting a Data Pump Import Job

    View Sample
    Chapter 23. Accessing Remote Data
    View Sample

    Section 23.1. Database Links

    View Sample

    Section 23.2. Using Synonyms for Location Transparency

    View Sample

    Section 23.3. Using the User Pseudo-Column in Views

    View Sample

    Section 23.4. Dynamic Links: Using the SQL*Plus copy Command

    View Sample

    Section 23.5. Connecting to a Remote Database

    View Sample
    Chapter 24. Using Materialized Views
    View Sample

    Section 24.1. Functionality

    View Sample

    Section 24.2. Required System Privileges

    View Sample

    Section 24.3. Required Table Privileges

    View Sample

    Section 24.4. Read-Only vs. Updatable

    View Sample

    Section 24.5. create materialized view Syntax

    View Sample

    Section 24.6. Using Materialized Views to Alter Query Execution Paths

    View Sample

    Section 24.7. Using DBMS_ADVISOR

    View Sample

    Section 24.8. Refreshing Materialized Views

    View Sample

    Section 24.9. create materialized view log Syntax

    View Sample

    Section 24.10. Altering Materialized Views and Logs

    View Sample

    Section 24.11. Dropping Materialized Views and Logs

    View Sample
    Chapter 25. Using Oracle Text for Text Searches
    View Sample

    Section 25.1. Adding Text to the Database

    View Sample

    Section 25.2. Text Queries and Text Indexes

    View Sample

    Section 25.3. Index Sets

    View Sample
    Chapter 26. Using External Tables
    View Sample

    Section 26.1. Accessing the External Data

    View Sample

    Section 26.2. Creating an External Table

    View Sample

    Section 26.3. Altering External Tables

    View Sample

    Section 26.4. Limitations, Benefits, and Potential Uses of External Tables

    View Sample
    Chapter 27. Using Flashback Queries
    View Sample

    Section 27.1. Time-Based Flashback Example

    View Sample

    Section 27.2. Saving the Data

    View Sample

    Section 27.3. SCN-Based Flashback Example

    View Sample

    Section 27.4. What If the Flashback Query Fails?

    View Sample

    Section 27.5. What SCN Is Associated with Each Row?

    View Sample

    Section 27.6. Flashback Version Queries

    View Sample

    Section 27.7. Planning for Flashbacks

    View Sample
    Chapter 28. Flashback—Tables and Databases
    View Sample

    Section 28.1. The flashback table Command

    View Sample

    Section 28.2. The flashback database Command

    View Sample

    Part 4: PL/SQL

    View Sample
    Chapter 29. An Introduction to PL/SQL
    View Sample

    Section 29.1. PL/SQL Overview

    View Sample

    Section 29.2. Declarations Section

    View Sample

    Section 29.3. Executable Commands Section

    View Sample

    Section 29.4. Exception Handling Section

    View Sample
    Chapter 30. Tiggers
    View Sample

    Section 30.1. Required System Privileges

    View Sample

    Section 30.2. Required Table Privileges

    View Sample

    Section 30.3. Types of Triggers

    View Sample

    Section 30.4. Trigger Syntax

    View Sample

    Section 30.5. Enabling and Disabling Triggers

    View Sample

    Section 30.6. Replacing Triggers

    View Sample

    Section 30.7. Dropping Triggers

    View Sample
    Chapter 31. Procedures, Functions, and Packages
    View Sample

    Section 31.1. Required System Privileges

    View Sample

    Section 31.2. Required Table Privileges

    View Sample

    Section 31.3. Procedures vs. Functions

    View Sample

    Section 31.4. Procedures vs. Packages

    View Sample

    Section 31.5. create procedure Syntax

    View Sample

    Section 31.6. create function Syntax

    View Sample

    Section 31.7. create package Syntax

    View Sample

    Section 31.8. Viewing Source Code for Procedural Objects

    View Sample

    Section 31.9. Compiling Procedures, Functions, and Packages

    View Sample

    Section 31.10. Replacing Procedures, Functions, and Packages

    View Sample

    Section 31.11. Dropping Procedures, Functions, and Packages

    View Sample
    Chapter 32. Using Native Dynamic SQL and DBMS_SQL
    View Sample

    Section 32.1. Using EXECUTE IMMEDIATE

    View Sample

    Section 32.2. Using Bind Variables

    View Sample

    Section 32.3. Using DBMS_SQL

    View Sample

    Part 5: Object-Relational Databases

    View Sample
    Chapter 33. Implementing Types, Object Views, and Methods
    View Sample

    Section 33.1. Working with Abstract Datatypes

    View Sample

    Section 33.2. Implementing Object Views

    View Sample

    Section 33.3. Methods

    View Sample
    Chapter 34. Collectors (Nested Tables and Varying Arrays)
    View Sample

    Section 34.1. Varying Arrays

    View Sample

    Section 34.2. Nested Tables

    View Sample

    Section 34.3. Additional Functions for Nested Tables and Varying Arrays

    View Sample

    Section 34.4. Management Issues for Nested Tables and Varying Arrays

    View Sample
    Chapter 35. Using Large Objects
    View Sample

    Section 35.1. Available Datatypes

    View Sample

    Section 35.2. Specifying Storage for LOB Data

    View Sample

    Section 35.3. Manipulating and Selecting LOB Values

    View Sample
    Chapter 36. Advanced Object-Oriented Concepts
    View Sample

    Section 36.1. Row Objects vs. Column Objects

    View Sample

    Section 36.2. Object Tables and OIDs

    View Sample

    Section 36.3. Object Views with REFs

    View Sample

    Section 36.4. Object PL/SQL

    View Sample

    Section 36.5. Objects in the Database

    View Sample

    Part 6: Java in Oracle

    View Sample
    Chapter 37. An Introduction to Java
    View Sample

    Section 37.1. Java vs. PL/SQL: An Overview

    View Sample

    Section 37.2. Getting Started

    View Sample

    Section 37.3. Declarations

    View Sample

    Section 37.4. Executable Commands

    View Sample

    Section 37.5. Classes

    View Sample
    Chapter 38. JDBC Programming
    View Sample

    Section 38.1. Getting Started

    View Sample

    Section 38.2. Using the JDBC Classes

    View Sample
    Chapter 39. Java Stored Procedures
    View Sample

    Section 39.1. Loading the Class into the Database

    View Sample

    Section 39.2. How to Access the Class

    View Sample

    Part 7: Clustered Oracle—The Grid

    View Sample
    Chapter 40. Oracle Real Application Clusters
    View Sample

    Section 40.1. Preinstallation Steps

    View Sample

    Section 40.2. Installing RAC

    View Sample

    Section 40.3. Starting and Stopping RAC Instances

    View Sample

    Section 40.4. Transparent Application Failover

    View Sample

    Section 40.5. Adding Nodes and Instances to the Cluster

    View Sample

    Section 40.6. Managing the Cluster Registry and Services

    View Sample
    Chapter 41. Grid Architecture and Management
    View Sample

    Section 41.1. Hardware and Operating System Configuration Issues

    View Sample

    Section 41.2. Adding Servers to the Grid

    View Sample

    Section 41.3. Sharing Data Across the Grid

    View Sample

    Section 41.4. Managing the Grid

    View Sample

    Section 41.5. Launching OEM

    View Sample

    Part 8: Hitchhiker's Guides

    View Sample
    Chapter 42. The Hitchhiker's Guide to the Oracle Data Dictionary
    View Sample

    Section 42.1. A Note about Nomenclature

    View Sample

    Section 42.2. New Views Introduced in Oracle Database 10g

    View Sample

    Section 42.3. New Columns Introduced in Oracle Database 10g

    View Sample

    Section 42.4. The Road Maps: DICTIONARY (DICT) and DICT_COLUMNS

    View Sample

    Section 42.5. Things You Select From: Tables (and Columns), Views, Synonyms, and Sequences

    View Sample

    Section 42.6. Recycle Bin—USER_RECYCLEBIN and DBA_RECYCLEBIN

    View Sample

    Section 42.7. Constraints and Comments

    View Sample

    Section 42.8. Abstract Datatypes, ORDBMS-Related Structures, and LOBs

    View Sample

    Section 42.9. Database Links and Materialized Views

    View Sample

    Section 42.10. Triggers, Procedures, Functions, and Packages

    View Sample

    Section 42.11. Dimensions

    View Sample

    Section 42.12. Space Allocation and Usage, Including Partitions and Subpartitions

    View Sample

    Section 42.13. Users and Privileges

    View Sample

    Section 42.14. Roles

    View Sample

    Section 42.15. Auditing

    View Sample

    Section 42.16. Miscellaneous

    View Sample

    Section 42.17. Monitoring: The V$ Dynamic Performance Tables

    View Sample
    Chapter 43. The Hitchhiker's Guide to Tuning Applications and SQL
    View Sample

    Section 43.1. New Tuning Features in Oracle Database 10g

    View Sample

    Section 43.2. Tuning—Best Practices

    View Sample

    Section 43.3. Generating and Reading Explain Plans

    View Sample

    Section 43.4. Major Operations Within Explain Plans

    View Sample

    Section 43.5. Implementing Stored Outlines

    View Sample

    Section 43.6. Review

    View Sample
    Chapter 44. Case Studies in Tuning
    View Sample

    Section 44.1. Case Study 1: Waits, Waits, and More Waits

    View Sample

    Section 44.2. Case Study 2: Application-Killing Queries

    View Sample

    Section 44.3. Case Study 3: Long-Running Batch Jobs

    View Sample
    Chapter 45. The Hitchhiker's Guide to Oracle Application Server 10g
    View Sample

    Section 45.1. What Is Oracle Application Server 10g?

    View Sample

    Section 45.2. Communication Services

    View Sample

    Section 45.3. Content Management Services

    View Sample

    Section 45.4. Business Logic Services

    View Sample

    Section 45.5. Presentation Services

    View Sample

    Section 45.6. Business Intelligence Services

    View Sample

    Section 45.7. Portal Services

    View Sample

    Section 45.8. Web Services

    View Sample

    Section 45.9. Developer Toolkits

    View Sample

    Section 45.10. Persistence Layer Services

    View Sample

    Section 45.11. Caching Services

    View Sample

    Section 45.12. System Services

    View Sample

    Section 45.13. Development Tools

    View Sample
    Chapter 46. The Hitchhiker's Guide to Database Administration
    View Sample

    Section 46.1. Creating a Database

    View Sample

    Section 46.2. Starting and Stopping the Database

    View Sample

    Section 46.3. Sizing and Managing Memory Areas

    View Sample

    Section 46.4. Allocating and Managing Space for the Objects

    View Sample

    Section 46.5. Monitoring an Undo Tablespace

    View Sample

    Section 46.6. Automating Storage Management

    View Sample

    Section 46.7. Segment Space Management

    View Sample

    Section 46.8. Transporting Tablespaces

    View Sample

    Section 46.9. Performing Backups

    View Sample

    Section 46.10. Where to Go from Here

    View Sample
    Chapter 47. The Hitchhiker's Guide to XML in Oracle
    View Sample

    Section 47.1. Document Type Definitions, Elements, and Attributes

    View Sample

    Section 47.2. XML Schema

    View Sample

    Section 47.3. Using XSU to Select, Insert, Update, and Delete XML Values

    View Sample

    Section 47.4. Using XMLType

    View Sample

    Section 47.5. Other Features

    View Sample

    Part 9: Alphabetical Reference

    View Sample

    Index