Skip to content

Oracle Database 10g The Complete Reference

Spend $50 to get a free DVD!

ISBN-10: 0072253517

ISBN-13: 9780072253511

Edition: 2004

Authors: Kevin Loney

List price: $75.00
Blue ribbon 30 day, 100% satisfaction guarantee!
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Customers also bought

Book details

List price: $75.00
Copyright year: 2004
Publisher: McGraw-Hill Osborne
Publication date: 9/28/2004
Binding: Paperback
Pages: 1392
Size: 7.25" wide x 8.75" long x 3.00" tall
Weight: 4.950
Language: English

Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine.

Acknowledgements
Introduction
Critical Database Concepts
Oracle Database 10g Architecture Options
Databases and Instances
Inside the Database
Choosing Architectures and Options
Installing Oracle Database 10g and Creating a Database
Overview of Licensing and Installation Options
Upgrading to Oracle Database 10g
Choosing an Upgrade Method
Before Upgrading
Using the Database Upgrade Assistant
Performing a Manual Direct Upgrade
Using Export and Import
Using the Data-Copying Method
After Upgrading
Planning Oracle Applications-Approaches, Risks, and Standards
The Cooperative Approach
Everyone Has "Data"
The Familiar Language of Oracle
Some Common, Everyday Examples
What Are the Risks?
The Importance of the New Vision
How to Reduce the Confusion
Capitalization in Names and Data
Normalizing Names
Good Design Has a Human Touch
Understanding the Data
Toward Object Name Normalization
Intelligent Keys and Column Values
The Commandments
SQL and SQL*Plus
The Basic Parts of Speech in SQL
Style
Creating the NEWSPAPER Table
Using SQL to Select Data from Tables
Select, from, where, and order by
Logic and Value
Another Use for where: Subqueries
Combining Tables
Creating a View
Basic SQL*Plus Reports and Commands
Building a Simple Report
Other Features
Checking the SQL*Plus Environment
Building Blocks
Getting Text Information and Changing It
Datatypes
What Is a String?
Notation
Concatenation (II)
How to Cut and Paste Strings
Using order by and where with String Functions
Review
Searching for Regular Expressions
Search Strings
Regexp_Substr
Playing the Numbers
The Three Classes of Number Functions
Notation
Single-Value Functions
Aggregate Functions
List Functions
Finding Rows with MAX or MIN
Precedence and Parentheses
Review
Dates: Then, Now, and the Difference
Date Arithmetic
Round and Trunc in Data Calculations
To_Date and To_Char Formatting
Dates in where Clauses
Dealing with Multiple Centuries
Using the Extract Function
Using the Timestamp Datatypes
Conversion and Transformation Functions
Elementary Conversion Functions
Specialized Conversion Functions
Transformation Functions
Review
Grouping Things Together
The Use of group by and having
Views of Groups
The Power of Views of Groups
More Grouping Possibilities
When One Query Depends upon Another
Advanced Subqueries
Outer Joins
Natural and Inner Joins
Union, Intersect, and Minus
Some Complex Possibilities
Complex Groupings
Using Temporary Tables
Using Rollup, Grouping, and Cube
Family Trees and connect by
Changing Data: insert, update, merge, and delete
Insert
Rollback, commit, and autocommit
Multitable Inserts
Delete
Update
Using the merge Command
Decode and Case: if, then, and else in SQL
If, then, else
Replacing Values via Decode
Decode Within Decode
Greater Than and Less Than in Decode
Using Case
Creating and Managing Tables, Views, Indexes, Clusters, and Sequences
Creating a Table
Dropping Tables
Altering Tables
Creating a Table from a Table
Creating an Index-Organized Table
Using Partitioned Tables
Creating a View
Indexes
Clusters
Sequences
Basic Oracle Security
Users, Roles, and Privileges
What Users Can Grant
Granting Limited Resources
Beyond the Basics
Advanced Security-Virtual Private Databases
Initial Configuration
Create an Application Context
Create a Logon Trigger
Create a Security Policy
Apply the Security Policy to Tables
Test VPD
How to Implement Column-Level VPD
How to Disable VPD
How to Use Policy Groups
Working with Tablespaces
Tablespaces and the Structure of the Database
Planning Your Tablespace Usage
Using SQL*Loader to Load Data
The Control File
Starting the Load
Control File Syntax Notes
Managing Data Loads
Tuning Data Loads
Additional Features
Using Data Pump Export and Import
Creating a Directory
Data Pump Export Options
Starting a Data Pump Export Job
Data Pump Import Options
Starting a Data Pump Import Job
Accessing Remote Data
Database Links
Using Synonyms for Location Transparency
Using the User Pseudo-Column in Views
Dynamic Links: Using the SQL*Plus copy Command
Connecting to a Remote Database
Using Materialized Views
Functionality
Required System Privileges
Required Table Privileges
Read-Only vs. Updatable
Create materialized view Syntax
Using Materialized Views to Alter Query Execution Paths
Using DBMS_ADVISOR
Refreshing Materialized Views
Create materialized view log Syntax
Altering Materialized Views and Logs
Dropping Materialized Views and Logs
Using Oracle Text for Text Searches
Adding Text to the Database
Text Queries and Text Indexes
Index Sets
Using External Tables
Accessing the External Data
Creating an External Table
Altering External Tables
Limitations, Benefits, and Potential Uses of External Tables
Using Flashback Queries
Time-Based Flashback Example
Saving the Data
SCN-Based Flashback Example
What If the Flashback Query Fails?
What SCN Is Associated with Each Row?
Flashback Version Queries
Planning for Flashbacks
Flashback-Tables and Databases
The flashback table Command
The flashback database Command
PL/SQL
An Introduction to PL/SQL
PL/SQL Overview
Declarations Section
Executable Commands Section
Exception Handling Section
Triggers
Required System Privileges
Required Table Privileges
Types of Triggers
Trigger Syntax
Enabling and Disabling Triggers
Replacing Triggers
Dropping Triggers
Procedures, Functions, and Packages
Required System Privileges
Required Table Privileges
Procedures vs. Functions
Procedures vs. Packages
Create procedure Syntax
Create function Syntax
Create package Syntax
Viewing Source Code for Procedural Objects
Compiling Procedures, Functions, and Packages
Replacing Procedures, Functions, and Packages
Dropping Procedures, Functions, and Packages
Using Native Dynamic SQL and DBMS_SQL
Using EXECUTE IMMEDIATE
Using Bind Variables
Using DBMS_SQL
Object-Relational Databases
Implementing Types, Object Views, and Methods
Working with Abstract Datatypes
Implementing Object Views
Methods
Collectors (Nested Tables and Varying Arrays)
Varying Arrays
Nested Tables
Additional Functions for Nested Tables and Varying Arrays
Management Issues for Nested Tables and Varying Arrays
Using Large Objects
Available Datatypes
Specifying Storage for LOB Data
Manipulating and Selecting LOB Values
Advanced Object-Oriented Concepts
Row Objects vs. Column Objects
Object Tables and OIDs
Object Views with REFs
Object PL/SQL
Objects in the Database
Java in Oracle
An Introduction to Java
Java vs. PL/SQL: An Overview
Getting Started
Declarations
Executable Commands
Classes
JDBC Programming
Getting Started
Using the JDBC Classes
Java Stored Procedures
Loading the Class into the Database
How to Access the Class
Clustered Oracle-The Grid
Oracle Real Application Clusters
Preinstallation Steps
Installing RAC
Starting and Stopping RAC Instances
Transparent Application Failover
Adding Nodes and Instances to the Cluster
Managing the Cluster Registry and Services
Grid Architecture and Management
Hardware and Operating System Configuration Issues
Adding Servers to the Grid
Sharing Data Across the Grid
Managing the Grid
Launching OEM
Hitchhiker's Guides
The Hitchhiker's Guide to the Oracle Data Dictionary
A Note About Nomenclature
New Views Introduced in Oracle Database 10g
New Columns Introduced in Oracle Database 10g
The Road Maps: DICTIONARY (DICT) and DICT_COLUMNS
Things You Select From: Tables (and Columns), Views, Synonyms, and Sequences
Recycle Bin-USER_RECYCLEBIN and DBA_RECYCLEBIN
Constraints and Comments
Abstract Datatypes, ORDBMS-Related Structures, and LOBs
Database Links and Materialized Views
Triggers, Procedures, Functions, and Packages
Dimensions
Space Allocation and Usage, Including Partitions and Subpartitions
Users and Privileges
Roles
Auditing
Miscellaneous
Monitoring: The V$ Dynamic Performance Tables
The Hitchhiker's Guide to Tuning Applications and SQL
New Tuning Features in Oracle Database 10g
Tuning-Best Practices
Generating and Reading Explain Plans
Major Operations Within Explain Plans
Implementing Stored Outlines
Review
Case Studies in Tuning
Waits, Waits, and More Waits
Application-Killing Queries
Long-Running Batch Jobs
The Hitchhiker's Guide to Oracle Application Server 10g
What Is Oracle Application Server 10g?
Communication Services
Content Management Services
Business Logic Services
Presentation Services
Business Intelligence Services
Portal Services
Web Services
Developer Toolkits
Persistence Layer Services
Caching Services
System Services
Development Tools
The Hitchhiker's Guide to Database Administration
Creating a Database
Starting and Stopping the Database
Sizing and Managing Memory Areas
Allocating and Managing Space for the Objects
Monitoring an Undo Tablespace
Automating Storage Management
Segment Space Management
Transporting Tablespaces
Performing Backups
Where to Go from Here
The Hitchhiker's Guide to XML in Oracle
Document Type Definitions, Elements, and Attributes
XML Schema
Using XSU to Select, Insert, Update, and Delete XML Values
Using XML Type
Other Features
Alphabetical Reference
Index