An A-Z Index of Oracle SQL commands

A
   ANALYZE
   AUDIT
C
   CALL
   Cluster - CREATE CLUSTER
           - ALTER  CLUSTER
           - DROP   CLUSTER
   COMMENT
   COMMIT
   CONNECT
   CONSTRAINT - Add / Enable
   Context - CREATE CONTEXT
           - DROP CONTEXT
   Controlfile - CREATE CONTROLFILE
D
   Database - CREATE DATABASE
            - ALTER  DATABASE
   DELETE
   DESCRIBE
   Dimension - CREATE DIMENSION
             - ALTER DIMENSION
             - DROP DIMENSION
   Directory - CREATE DIRECTORY
             - DROP DIRECTORY
E
   EXEC
   EXECUTE IMMEDIATE
   EXPDP - Export (Data Pump)
   EXPLAIN PLAN
F
   Function - CREATE FUNCTION
         - ALTER  FUNCTION
         - DROP   FUNCTION
G
   GRANT
I
   IMPDP - Import (Data Pump)
   Index - CREATE INDEX
         - ALTER  INDEX
         - DROP   INDEX
   Indextype - CREATE INDEXTYPE
             - DROP INDEXTYPE
   INSERT
   INTERSECT
J
   Java - CREATE JAVA
        - ALTER JAVA
        - DROP JAVA
L
   Library - CREATE LIBRARY
           - DROP LIBRARY
   Link - CREATE DATABASE LINK
        - DROP DATABASE LINK
   LOCK TABLE
M
   MERGE - Select rows for update or insert into a table.
   Mview - CREATE MATERIALIZED VIEW
         - ALTER MATERIALIZED VIEW
         - DROP MATERIALIZED VIEW
         - CREATE MATERIALIZED VIEW LOG
         - ALTER MATERIALIZED VIEW LOG
         - DROP MATERIALIZED VIEW LOG
   MINUS
N
   NOAUDIT
O
   Operator - CREATE OPERATOR
            - DROP OPERATOR
   Outline - CREATE OUTLINE
           - ALTER OUTLINE
           - DROP OUTLINE
P
   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
   PURGE RECYCLEBIN / Table
R
   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
S
   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
T
   Table - CREATE TABLE
         - ALTER  TABLE
         - DROP   TABLE
   Tablespace - CREATE TABLESPACE
              - ALTER  TABLESPACE
              - DROP   TABLESPACE
              - CREATE TEMPORARY TABLESPACE
   TNSPING - Test listener connection
   Transaction - SET TRANSACTION
   Trigger - CREATE TRIGGER
           - ALTER  TRIGGER
           - DROP   TRIGGER
   TRUNCATE
   Type - CREATE TYPE
        - ALTER TYPE
        - DROP TYPE
        - CREATE TYPE BODY
        - DROP TYPE BODY
U
   UPDATE
   UNION
   User - CREATE USER
        - ALTER  USER
        - DROP   USER
V
   View - CREATE VIEW
        - ALTER  VIEW
        - DROP   VIEW
W
   WHERE

To scroll this page, press [ a – z ] on the keyboard, [\] = Search.

Syntax:
Words in CAPS are Oracle commands, words in lower-case are the options you can modify.
Sections enclosed in [ ] are optional, underlined options are the default
Sections enclosed in { } are alternatives. The pipe symbol `|` indicates OR (more)

The syntax on these pages is based on basic commands from Oracle version 9.2 - 10g, newer versions of Oracle add a raft of additional functionality: RAC, Data Guard etc, for the full details of those see docs.oracle.com
Links to other Sites, books etc…