Oracle Data DictionaryOracle SyntaxOracle Books, Websites etc

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...



Back to the Top

Simon Sheppard
SS64.com