今天发现了一个显示ORACLE语法的好网站。内容太多，就不一一摘录了，记在这里，也方便自己查找。

http://www.ss64.com/ora/

目录如下：

An A-Z Index of Oracle SQL Commands (version 9.2)

ANALYZE

AUDIT

CALL

Cluster - CREATE CLUSTER

- ALTER CLUSTER

- DROP CLUSTER

COMMENT

COMMIT

CONNECT

CONSTRAINT - Add / Enable

Context - CREATE CONTEXT

- DROP CONTEXT

Controlfile - CREATE CONTROLFILE

Database - CREATE DATABASE

- ALTER DATABASE

DELETE

DESCRIBE

Dimension - CREATE DIMENSION

- ALTER DIMENSION

- DROP DIMENSION

Directory - CREATE DIRECTORY

- DROP DIRECTORY

EXEC

EXECUTE IMMEDIATE

EXPLAIN PLAN

Function - CREATE FUNCTION

- ALTER FUNCTION

- DROP FUNCTION

GRANT

Index - CREATE INDEX

- ALTER INDEX

- DROP INDEX

Indextype - CREATE INDEXTYPE

- DROP INDEXTYPE

INSERT

INTERSECT

Java - CREATE JAVA

- ALTER JAVA

- DROP JAVA

Library - CREATE LIBRARY

- DROP LIBRARY

Link - CREATE DATABASE LINK

- DROP DATABASE LINK

LOCK TABLE

Mview - CREATE MATERIALIZED VIEW

- ALTER MATERIALIZED VIEW

- DROP MATERIALIZED VIEW

- CREATE MATERIALIZED VIEW LOG

- ALTER MATERIALIZED VIEW LOG

- DROP MATERIALIZED VIEW LOG

MINUS

NOAUDIT

Operator - CREATE OPERATOR

- DROP OPERATOR

Outline - CREATE OUTLINE

- ALTER OUTLINE

- DROP OUTLINE

Package - CREATE PACKAGE/BODY

- ALTER PACKAGE

- DROP PACKAGE

Pfile - CREATE PFILE

Procedure - CREATE PROCEDURE

- ALTER PROCEDURE

- DROP PROCEDURE

Profile - CREATE PROFILE

- ALTER PROFILE

- DROP PROFILE

RECOVER

RENAME

Resource - ALTER RESOURCE COST

REVOKE

RMAN - Recovery Manager

Role - CREATE ROLE

- SET ROLE

- ALTER ROLE

- DROP ROLE

ROLLBACK

Rollback - CREATE ROLLBACK SEGMENT

- ALTER ROLLBACK SEGMENT

- DROP ROLLBACK SEGMENT

SAVEPOINT

Schema - CREATE SCHEMA

SELECT

Sequence - CREATE SEQUENCE

- ALTER SEQUENCE

- DROP SEQUENCE

Session - ALTER SESSION

SHUTDOWN

SNAPSHOT

SPfile - CREATE SPFILE

STARTUP

Statistics - ASSOCIATE STATISTICS

- DISASSOCIATE STATISTICS

Synonym - CREATE SYNONYM

- DROP SYNONYM

System - ALTER SYSTEM

Table - CREATE TABLE

- ALTER TABLE

- DROP TABLE

Tablespace - CREATE TABLESPACE

- ALTER TABLESPACE

- DROP TABLESPACE

- CREATE TEMPORARY TABLESPACE

Transaction - SET TRANSACTION

Trigger - CREATE TRIGGER

- ALTER TRIGGER

- DROP TRIGGER

TRUNCATE

Type - CREATE TYPE

- ALTER TYPE

- DROP TYPE

- CREATE TYPE BODY

- DROP TYPE BODY

UPDATE

UNION

User - CREATE USER

- ALTER USER

- DROP USER

View - CREATE VIEW

- ALTER VIEW

- DROP VIEW