top of page
CerebroSQL

SQL Tutorial for Oracle

Description of SQL syntax and DDL commands supported by Oracle DBMS with usage examples.

oracle-logo

ALTER CLUSTER

ALTER DATABASE

ALTER DATABASE LINK

ALTER DIMENSION

ALTER DISKGROUP

ALTER FLASHBACK ARCHIVE

ALTER FUNCTION

ALTER INDEX

ALTER INDEXTYPE

ALTER JAVA

ALTER LIBRARY

ALTER MATERIALIZED VIEW

ALTER MATERIALIZED VIEW LOG

ALTER OPERATOR

ALTER OUTLINE

ALTER PACKAGE

ALTER PROCEDURE

ALTER PROFILE

ALTER RESOURCE COST

ALTER ROLE

ALTER ROLLBACK SEGMENT

ALTER SEQUENCE

ALTER SESSION

ALTER SYSTEM

ALTER TABLE

ALTER TABLESPACE

ALTER TRIGGER

ALTER TYPE

ALTER USER

ALTER VIEW

ANALYZE

ASSOCIATE STATISTICS

AUDIT

CALL

COMMENT

COMMIT

CREATE CLUSTER

CREATE CONTEXT

CREATE CONTROLFILE

CREATE DATABASE

CREATE DATABASE LINK

CREATE DIMENSION

CREATE DIRECTORY

CREATE DISKGROUP

CREATE EDITION

CREATE FLASHBACK ARCHIVE

CREATE FUNCTION

CREATE INDEX

CREATE INDEXTYPE

CREATE JAVA

CREATE LIBRARY

CREATE MATERIALIZED VIEW

CREATE MATERIALIZED VIEW LOG

CREATE OPERATOR

CREATE OUTLINE

CREATE PACKAGE

CREATE PACKAGE BODY

CREATE PFILE

CREATE PROCEDURE

CREATE PROFILE

CREATE RESTORE POINT

CREATE ROLE

CREATE ROLLBACK SEGMENT

CREATE SCHEMA

CREATE SEQUENCE

CREATE SPFILE

CREATE SYNONYM

CREATE TABLE

CREATE TABLESPACE

CREATE TRIGGER

CREATE TYPE

CREATE TYPE BODY

CREATE USER

CREATE VIEW

DBMS_OUTPUT

DELETE

DISASSOCIATE STATISTICS

DROP CLUSTER

DROP CONTEXT

DROP DATABASE

DROP DATABASE LINK

DROP DIMENSION

DROP DIRECTORY

DROP DISKGROUP

DROP EDITION

DROP FLASHBACK ARCHIVE

DROP FUNCTION

DROP INDEX

DROP INDEXTYPE

DROP JAVA

DROP LIBRARY

DROP MATERIALIZED VIEW

DROP MATERIALIZED VIEW LOG

DROP OPERATOR

DROP OUTLINE

DROP PACKAGE

DROP PROCEDURE

DROP PROFILE

DROP RESTORE POINT

DROP ROLE

DROP ROLLBACK SEGMENT

DROP SEQUENCE

DROP SYNONYM

DROP TABLE

DROP TABLESPACE

DROP TRIGGER

DROP TYPE

DROP TYPE BODY

DROP USER

DROP VIEW

EXPLAIN PLAN

FLASHBACK DATABASE

FLASHBACK TABLE

GRANT

INSERT

LOCK TABLE

MERGE

NOAUDIT

PURGE

RENAME

REVOKE

ROLLBACK

SAVEPOINT

SELECT

SET CONSTRAINTS

SET ROLE

SET TRANSACTION

TRUNCATE CLUSTER

TRUNCATE TABLE

UPDATE

bottom of page