Contents

Title and Copyright Information

Preface

What's New in the SQL Language Reference?

1 Introduction to Oracle SQL

2 Pseudocolumns

3 Basic Elements of Oracle SQL

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 LIBRARY 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 Automatic and Manual Locking Mechanisms During SQL Operations

C Oracle and Standard SQL

D Oracle Regular Expression Support

E Oracle SQL Reserved Words

F Extended Examples

Index