Contents

Title and Copyright Information

Preface

What's New in the SQL Reference?

1 Introduction to Oracle SQL

2 Basic Elements of Oracle SQL

3 Pseudocolumns

4 Operators

5 Functions

6 Expressions

7 Conditions

8 Common SQL DDL Clauses

9 SQL Queries and Subqueries

10 SQL Statements: ALTER CLUSTER to ALTER JAVA

11 SQL Statements: ALTER MATERIALIZED VIEW to ALTER SYSTEM

12 SQL Statements: ALTER TABLE to ALTER TABLESPACE

13 SQL Statements: ALTER TRIGGER to COMMIT

14 SQL Statements: CREATE CLUSTER to CREATE JAVA

15 SQL Statements: CREATE LIBRARY to CREATE SPFILE

16 SQL Statements: CREATE SYNONYM to CREATE TRIGGER

17 SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT

18 SQL Statements: DROP SEQUENCE to ROLLBACK

19 SQL Statements: SAVEPOINT to UPDATE

A How to Read Syntax Diagrams

B Oracle and Standard SQL

C Oracle Regular Expression Support

D Oracle Database Reserved Words

E Examples

Index