Oracle8i SQL Reference Release 8.1.5 A67779-01

Library Product Index

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Features and Functionality

Audience

How this Reference Is Organized

What's New in This Release?

Conventions Used in this Reference

Your Comments Are Welcome

1 Introduction

History of SQL

SQL Standards

Embedded SQL

Lexical Conventions

Tools Support

2 Basic Elements of Oracle SQL

Literals

Datatypes

Format Models

Nulls

Pseudocolumns

Comments

Database Objects

Schema Object Names and Qualifiers

Referring to Schema Objects and Parts

3 Operators

Unary and Binary Operators

Precedence

Arithmetic Operators

Concatenation Operator

Comparison Operators

Logical Operators

Set Operators

Other Built-In Operators

User-Defined Operators

4 Functions

SQL Functions

User-Defined Functions

5 Expressions, Conditions, and Queries

Expressions

Conditions

Queries and Subqueries

6 About SQL Statements

Summary of SQL Statements

Finding the Right SQL Statement

7 SQL Statements

ALTER CLUSTER

ALTER DATABASE

ALTER DIMENSION

ALTER FUNCTION

ALTER INDEX

ALTER JAVA

ALTER MATERIALIZED VIEW / SNAPSHOT

ALTER MATERIALIZED VIEW LOG / SNAPSHOT LOG

ALTER OUTLINE

ALTER PACKAGE

ALTER PROCEDURE

ALTER PROFILE

ALTER RESOURCE COST

ALTER ROLE

ALTER ROLLBACK SEGMENT

ALTER SEQUENCE

ALTER SESSION

ALTER SNAPSHOT

ALTER SNAPSHOT LOG

ALTER SYSTEM

ALTER TABLE

ALTER TABLESPACE

ALTER TRIGGER

ALTER TYPE

ALTER USER

ALTER VIEW

ANALYZE

ASSOCIATE STATISTICS

AUDIT sql_statements

AUDIT schema_objects

CALL

COMMENT

COMMIT

constraint_clause

CREATE CLUSTER

CREATE CONTEXT

CREATE CONTROLFILE

CREATE DATABASE

CREATE DATABASE LINK

CREATE DIMENSION

CREATE DIRECTORY

CREATE FUNCTION

CREATE INDEX

CREATE INDEXTYPE

CREATE JAVA

CREATE LIBRARY

CREATE MATERIALIZED VIEW / SNAPSHOT

CREATE MATERIALIZED VIEW LOG / SNAPSHOT LOG

CREATE OPERATOR

CREATE OUTLINE

CREATE PACKAGE

CREATE PACKAGE BODY

CREATE PROCEDURE

CREATE PROFILE

CREATE ROLE

CREATE ROLLBACK SEGMENT

CREATE SCHEMA

CREATE SEQUENCE

CREATE SNAPSHOT

CREATE SNAPSHOT LOG

CREATE SYNONYM

CREATE TABLE

CREATE TABLESPACE

CREATE TEMPORARY TABLESPACE

CREATE TRIGGER

CREATE TYPE

CREATE TYPE BODY

CREATE USER

CREATE VIEW

DELETE

DISASSOCIATE STATISTICS

DROP CLUSTER

DROP CONTEXT

DROP DATABASE LINK

DROP DIMENSION

DROP DIRECTORY

DROP FUNCTION

DROP INDEX

DROP INDEXTYPE

DROP JAVA

DROP LIBRARY

DROP MATERIALIZED VIEW / SNAPSHOT

DROP MATERIALIZED VIEW LOG / SNAPSHOT LOG

DROP OPERATOR

DROP OUTLINE

DROP PACKAGE

DROP PROCEDURE

DROP PROFILE

DROP ROLE

DROP ROLLBACK SEGMENT

DROP SEQUENCE

DROP SNAPSHOT

DROP SNAPSHOT LOG

DROP SYNONYM

DROP TABLE

DROP TABLESPACE

DROP TRIGGER

DROP TYPE

DROP TYPE BODY

DROP USER

DROP VIEW

EXPLAIN PLAN

filespec

GRANT system_privileges_and_roles

GRANT object_privileges

INSERT

LOCK TABLE

NOAUDIT sql_statements

NOAUDIT schema_objects

RENAME

REVOKE system_privileges_and_roles

REVOKE schema_object_privileges

ROLLBACK

SAVEPOINT

SELECT and Subqueries

SET CONSTRAINT(S)

SET ROLE

SET TRANSACTION

storage_clause

TRUNCATE

UPDATE

A Syntax Diagrams

B Oracle and Standard SQL

Conformance with Standard SQL

Oracle Extensions to Standard SQL

C Oracle Reserved Words

Next

Copyright © 1999 Oracle Corporation. All Rights Reserved.

Library Product Index