RMAN - Recovery Manager
Database - CREATE DATABASE

          - DROP DIMENSION
Procedure - CREATE PROCEDURE
         - DROP   SEQUENCE
NOAUDIT
     - DROP DATABASE LINK
         - ALTER  FUNCTION
TRUNCATE
Library - CREATE LIBRARY

      - DROP MATERIALIZED VIEW LOG

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


Java - CREATE JAVA
Operator - CREATE OPERATOR

INSERT

     - DROP   USER
CALL

Package - CREATE PACKAGE/BODY


AUDIT
        - ALTER  TRIGGER
SAVEPOINT
         - DROP   ROLLBACK SEGMENT
          - ALTER  PROCEDURE

Outline - CREATE OUTLINE

目录如下：

        - ALTER  PACKAGE
        - DROP CONTEXT
Table - CREATE TABLE
      - ALTER  TABLE
         - DROP   FUNCTION
     - SET    ROLE
Function - CREATE FUNCTION
EXEC
         - ALTER  SEQUENCE
Role - CREATE ROLE
      - DROP   TABLE
        - DROP   PACKAGE

           - CREATE TEMPORARY TABLESPACE
         - ALTER  DATABASE
      - ALTER MATERIALIZED VIEW LOG
DESCRIBE
SNAPSHOT
RENAME

     - CREATE TYPE BODY
SHUTDOWN
     - DROP JAVA
Link - CREATE DATABASE LINK
Tablespace - CREATE TABLESPACE
UPDATE

EXPLAIN PLAN
Index - CREATE INDEX

View - CREATE VIEW
COMMENT
         - ALTER  ROLLBACK SEGMENT
Trigger - CREATE TRIGGER

        - DROP   CLUSTER
Rollback - CREATE ROLLBACK SEGMENT
MINUS
ROLLBACK
Indextype - CREATE INDEXTYPE
Pfile - CREATE PFILE
RECOVER
     - DROP TYPE BODY
CONSTRAINT - Add / Enable
Statistics - ASSOCIATE STATISTICS
INTERSECT
      - DROP   INDEX
Controlfile - CREATE CONTROLFILE
Synonym - CREATE SYNONYM
        - DROP   SYNONYM
Directory - CREATE DIRECTORY
          - DROP INDEXTYPE
        - ALTER  CLUSTER
Session - ALTER SESSION
Type - CREATE TYPE
SELECT
           - DISASSOCIATE STATISTICS
      - ALTER  INDEX

     - DROP   VIEW

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

        - DROP LIBRARY
     - DROP TYPE
     - ALTER  USER

CONNECT
COMMIT
          - DROP   PROCEDURE
REVOKE
        - ALTER OUTLINE
     - ALTER TYPE
ANALYZE
EXECUTE IMMEDIATE
        - DROP OUTLINE
     - ALTER  ROLE
Dimension - CREATE DIMENSION

Schema - CREATE SCHEMA
     - DROP   ROLE


      - CREATE MATERIALIZED VIEW LOG
User - CREATE USER
        - DROP   TRIGGER
      - DROP MATERIALIZED VIEW
UNION
Resource - ALTER RESOURCE COST
         - DROP OPERATOR
Profile - CREATE PROFILE
SPfile - CREATE SPFILE
Mview - CREATE MATERIALIZED VIEW
System - ALTER SYSTEM
     - ALTER  VIEW
          - DROP DIRECTORY
           - ALTER  TABLESPACE
Transaction - SET TRANSACTION
GRANT
      - ALTER MATERIALIZED VIEW
           - DROP   TABLESPACE
STARTUP
     - ALTER JAVA
          - ALTER DIMENSION
DELETE
Cluster - CREATE CLUSTER
        - ALTER  PROFILE

LOCK TABLE
Sequence - CREATE SEQUENCE
        - DROP   PROFILE

Context - CREATE CONTEXT