An A-Z Index of Oracle SQL Commands

An A-Z Index of Oracle SQL Commands

ANALYZE
AUDIT
CALL
CLUSTER - CREATE CLUSTER
CLUSTER - ALTER  CLUSTER
CLUSTER - DROP   CLUSTER
COMMENT
COMMIT
CONNECT
CONSTRAINT - Add / Enable
CONTEXT - CREATE CONTEXT
CONTEXT - DROP CONTEXT
CONTROLFILE - CREATE CONTROLFILE

DATABASE - CREATE DATABASE
DATABASE - ALTER  DATABASE
DELETE
DESCRIBE
DIMENSION - CREATE DIMENSION
DIMENSION - ALTER DIMENSION
DIMENSION - DROP DIMENSION
DIRECTORY - CREATE DIRECTORY
DIRECTORY - DROP DIRECTORY

EXEC
EXECUTE IMMEDIATE
EXPLAIN PLAN

FUNCTION - CREATE FUNCTION
FUNCTION - ALTER  FUNCTION
FUNCTION - DROP   FUNCTION

GRANT

INDEX - CREATE INDEX
INDEX - ALTER  INDEX
INDEX - DROP   INDEX
INDEXTYPE - CREATE INDEXTYPE
INDEXTYPE - DROP INDEXTYPE
INSERT
INTERSECT

JAVA - CREATE JAVA
JAVA - ALTER JAVA
JAVA - DROP JAVA

LIBRARY - CREATE LIBRARY
LIBRARY - DROP LIBRARY
LINK - CREATE DATABASE LINK
LINK - DROP DATABASE LINK
LOCK TABLE

MVIEW - CREATE MATERIALIZED VIEW
MVIEW - ALTER MATERIALIZED VIEW
MVIEW - DROP MATERIALIZED VIEW
MVIEW - CREATE MATERIALIZED VIEW LOG
MVIEW - ALTER MATERIALIZED VIEW LOG
MVIEW - DROP MATERIALIZED VIEW LOG
MINUS

NOAUDIT

OPERATOR - CREATE OPERATOR
OPERATOR - DROP OPERATOR
OUTLINE - CREATE OUTLINE
OUTLINE - ALTER OUTLINE
OUTLINE - DROP OUTLINE

PACKAGE - CREATE PACKAGE
PACKAGE - ALTER  PACKAGE
PACKAGE - DROP   PACKAGE
PACKAGE BODY - CREATE PACKAGE BODY
PROCEDURE - CREATE PROCEDURE
PROCEDURE - ALTER  PROCEDURE
PROCEDURE - DROP   PROCEDURE
PROFILE - CREATE PROFILE
PROFILE - ALTER  PROFILE
PROFILE - DROP   PROFILE

RECOVER
RENAME
RESOURCE - ALTER RESOURCE COST
REVOKE
ROLE - CREATE ROLE
ROLE - SET    ROLE
ROLE - ALTER  ROLE
ROLE - DROP   ROLE
ROLLBACK
ROLLBACK - CREATE ROLLBACK SEGMENT
ROLLBACK - ALTER  ROLLBACK SEGMENT
ROLLBACK - DROP   ROLLBACK SEGMENT

SAVEPOINT
SCHEMA - CREATE SCHEMA
SELECT
SEQUENCE - CREATE SEQUENCE
SEQUENCE - ALTER  SEQUENCE
SEQUENCE - DROP   SEQUENCE
SESSION - ALTER SESSION
SHUTDOWN
SNAPSHOT
STARTUP
STATISTICS - ASSOCIATE STATISTICS
STATISTICS - DISASSOCIATE STATISTICS
SYNONYM - CREATE SYNONYM
SYNONYM - DROP   SYNONYM
SYSTEM - ALTER SYSTEM

TABLE - CREATE TABLE
TABLE - ALTER  TABLE
TABLE - DROP   TABLE
TABLESPACE - CREATE TABLESPACE
TABLESPACE - ALTER  TABLESPACE
TABLESPACE - DROP   TABLESPACE
TABLESPACE - CREATE TEMPORARY TABLESPACE
TRANSACTION - SET TRANSACTION
TRIGGER - CREATE TRIGGER
TRIGGER - ALTER  TRIGGER
TRIGGER - DROP   TRIGGER
TRUNCATE
TYPE - CREATE TYPE
TYPE - ALTER TYPE
TYPE - DROP TYPE
TYPE - CREATE TYPE BODY
TYPE - DROP TYPE BODY

UPDATE
UNION
USER - CREATE USER
USER - ALTER  USER
USER - DROP   USER

VIEW - CREATE VIEW
VIEW - ALTER  VIEW
VIEW - DROP   VIEW

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

Other sources of help...




--------------------------------------------------------------------------------



Simon Sheppard
SS64.com