Oracle Database 10g SQL: Safari Books Online

Download Safari Books Online apps: Apple iOS | Android

Entire Site

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

Start Reading

Oracle Database 10g SQL

Oracle Database 10g SQL
By: Jason Price
Publisher: Oracle Press
Pub. Date: February 20, 2004
Print ISBN-10: 0-07-222981-0
Print ISBN-13: 978-0-07-222981-3
Web ISBN-10: 0-07-170670-4
Web ISBN-13: 978-0-07-170670-4
Pages in Print Edition: 600
Subscriber Rating: 0 [0 Ratings]

en

Subscriber Reviews • Browse Similar Topics

Overview

This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10g, and free code will be available for download.

Subscriber Reviews

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

No Subscribers have provided a review for this book.

Browse Similar Topics

Top Level Categories:
Information Technology & Software Development
Product
Vendor

Sub-Categories:
Information Technology & Software Development > Databases
Databases > SQL
Product > Oracle 10g
Vendor > Oracle

Table of Contents

View Sample

View Sample

About the Author

View Sample

Acknowledgments

View Sample

View Sample

Chapter 1. Introduction

View Sample

What Is a Relational Database?

View Sample

Introducing the Structured Query Language (SQL)

View Sample

View Sample

Performing a SELECT Statement Using SQL*Plus

View Sample

The SQL*Plus Worksheet

View Sample

Creating the Store Schema

View Sample

Adding, Modifying, and Removing Rows

View Sample

Modifying an Existing Row in a Table

View Sample

Removing a Row from a Table

View Sample

The New Oracle10g BINARY_FLOAT and BINARY_DOUBLE Types

View Sample

Quitting SQL*Plus

View Sample

Introducing Oracle PL/SQL

View Sample

View Sample

Chapter 2. Retrieving Information from Database Tables

View Sample

Performing Single Table SELECT Statements

View Sample

Selecting All Columns from a Table

View Sample

Understanding Row Identifiers

View Sample

Performing Arithmetic

View Sample

Using Column Aliases

View Sample

Merging Column Output Using Concatenation

View Sample

Understanding Null Values

View Sample

Displaying Distinct Rows

View Sample

Filtering Rows Using the WHERE Clause

View Sample

Sorting Rows Using the ORDER BY Clause

View Sample

Performing SELECT Statements that Use Two Tables

View Sample

Supplying Table Aliases

View Sample

Cartesian Products

View Sample

Performing SELECT Statements that Use More than Two Tables

View Sample

Understanding Join Conditions and Join Types

View Sample

Performing Joins Using the SQL/92 Syntax

View Sample

View Sample

Chapter 3. Using Simple Functions

View Sample

Using Single Row Functions

View Sample

Using Aggregate Functions

View Sample

View Sample

View Sample

Chapter 4. Storing and Processing Dates and Times

View Sample

Simple Examples of Storing and Retrieving Dates

View Sample

Converting Datetimes Using TO_CHAR() and TO DATE()

View Sample

Setting the Default Date Format

View Sample

How Oracle Interprets Two-Digit Years

View Sample

Using Datetime Functions

View Sample

Understanding Time Zones

View Sample

Using Timestamps

View Sample

Using Time Intervals

View Sample

View Sample

Chapter 5. Using SQL*Plus

View Sample

Viewing the Structure of a Table

View Sample

Editing SQL Statements

View Sample

Saving, Retrieving, and Running Files

View Sample

Formatting Columns

View Sample

Setting the Page Size

View Sample

Setting the Line Size

View Sample

Clearing Column Formatting

View Sample

Using Variables

View Sample

Creating Simple Reports

View Sample

Automatically Generating SQL Statements

View Sample

View Sample

Chapter 6. Subqueries

View Sample

Types of Subqueries

View Sample

Writing Single Row Subqueries

View Sample

Writing Multiple Row Subqueries

View Sample

Writing Multiple Column Subqueries

View Sample

Writing Correlated Subqueries

View Sample

Writing Nested Subqueries

View Sample

Writing UPDATE and DELETE Statements Containing Subqueries

View Sample

View Sample

Chapter 7. Advanced Queries

View Sample

Using the Set Operators

View Sample

Using the TRANSLATE() Function

View Sample

Using the DECODE() Function

View Sample

Using the CASE Expression

View Sample

Hierarchical Queries

View Sample

Using the Extended GROUP BY Clauses

View Sample

Using the ROLLUP Clause

View Sample

Using the Analytic Functions

View Sample

Using the MODEL Clause

View Sample

View Sample

Chapter 8. Changing Table Contents

View Sample

Adding Rows Using the INSERT Statement

View Sample

Modifying Rows Using the UPDATE Statement

View Sample

Removing Rows Using the DELETE Statement

View Sample

Database Integrity

View Sample

Using Default Values

View Sample

Merging Rows Using MERGE

View Sample

Database Transactions

View Sample

Query Flashbacks

View Sample

View Sample

Chapter 9. Database Security

View Sample

View Sample

System Privileges

View Sample

Object Privileges

View Sample

View Sample

View Sample

Chapter 10. Creating Tables, Sequences, Indexes, and Views

View Sample

View Sample

View Sample

View Sample

View Sample

View Sample

Chapter 11. Introducing PL/SQL Programming

View Sample

Block Structure

View Sample

Variables and Types

View Sample

Conditional Logic

View Sample

View Sample

View Sample

View Sample

View Sample

View Sample

View Sample

View Sample

View Sample

Chapter 12. Database Objects

View Sample

Introducing Objects

View Sample

Creating Object Types

View Sample

Using DESCRIBE to Get Information on Object Types

View Sample

Using Object Types to Define Column Objects and Object Tables

View Sample

Performing DML on the products Table

View Sample

Performing DML on the object_products Table

View Sample

Performing DML on the object_customers Table

View Sample

Performing DML on the purchases Table

View Sample

Using Objects in PL/SQL

View Sample

Type Inheritance

View Sample

NOT INSTANTIABLE Object Types

View Sample

User-Defined Constructors

View Sample

View Sample

Chapter 13. Collections

View Sample

Introducing Collections

View Sample

View Sample

View Sample

Multilevel Collection Types

View Sample

Using Collections in PL/SQL

View Sample

Oracle10g Enhancements to Collections

View Sample

View Sample

Chapter 14. Large Objects

View Sample

Introducing Large Objects (LOBs)

View Sample

The Example Files

View Sample

Understanding the Large Object Types

View Sample

Creating Tables Containing Large Objects

View Sample

Using Large Objects in SQL

View Sample

Using Large Objects in PL/SQL

View Sample

Understanding the LONG and LONG RAW Types

View Sample

Oracle Database 10g Enhancements to Large Objects

View Sample

View Sample

Chapter 15. Running SQL Using Java

View Sample

Getting Started

View Sample

Configuring Your Computer

View Sample

The Oracle JDBC Drivers

View Sample

Importing the JDBC Packages

View Sample

Registering the Oracle JDBC Drivers

View Sample

Opening a Database Connection

View Sample

Creating a JDBC Statement Object

View Sample

Retrieving Rows from the Database

View Sample

Adding Rows to the Database

View Sample

Modifying Rows in the Database

View Sample

Deleting Rows from the Database

View Sample

Handling Numbers

View Sample

Handling Database Null Values

View Sample

Controlling Database Transactions

View Sample

Performing Data Definition Language Statements

View Sample

Handling Exceptions

View Sample

Closing Your JDBC Objects

View Sample

Example Program: BasicExample1.java

View Sample

Prepared SQL Statements

View Sample

Example Program: BasicExample2.java

View Sample

The Oracle JDBC Extensions

View Sample

View Sample

Chapter 16. High Performance SQL Tuning

View Sample

Introducing SQL Tuning

View Sample

Use a WHERE Clause to Filter Rows

View Sample

Use Table Joins Rather than Multiple Queries

View Sample

Use Fully Qualified Column References When Performing Joins

View Sample

Use CASE Expressions Rather than Multiple Queries

View Sample

Add Indexes to Tables

View Sample

Use WHERE Rather than HAVING

View Sample

Use UNION ALL Rather than UNION

View Sample

Use EXISTS Rather than IN

View Sample

Use EXISTS Rather than DISTINCT

View Sample

Use Bind Variables

View Sample

Comparing the Cost of Performing Queries

View Sample

Passing Hints to the Optimizer

View Sample

Additional Tuning Tools

View Sample

View Sample

Oracle Data Types

View Sample

Oracle SQL Types

View Sample

Oracle PL/SQL Types