Oracle Database 10g SQL

Contents

ACKNOWLEDGMENTS

INTRODUCTION

1 Introduction

What Is a Relational Database?

Introducing the Structured Query Language (SQL)

Using SQL*Plus

Starting the Windows Version of SQL*Plus

Starting the Command-Line Version of SQL*Plus

Performing a SELECT statement Using SQL*Plus

The SQL*Plus Worksheet

Creating the Store Schema

Running the SQL*Plus Script to Create the Store Schema

Data Definition Language (DDL) Statements Used to Create the Store Schema

Adding, Modifying, and Removing Rows

Adding a Row to a Table

Modifying an Existing Row in a Table

Removing a Row from a Table

The New Oracle 10g BINARY_FLOAT and BINARY_DOUBLE Types

Benefits of BINARY_FLOAT and BINARY_DOUBLE

Using BINARY_FLOAT and BINARY_DOUBLE in a Table

Special Values

Quitting ...