An A-Z Index of Oracle SQL commands

   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

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

SS64 Oracle Discussion forum
Links to other Sites, books etc…


 
Copyright © 1999-2020 SS64.com
Some rights reserved