一个oracle指令的好网站

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

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