SELECT Statement

FROM Clause

Comparison Operators

WHERE Clause

ORDER BY Clause

AND Condition

OR Condition

Combining the AND and OR Conditions

DISTINCT Clause

IN Condition

IS NULL Condition

IS NOT NULL Condition

LIKE Condition

REGEXP_LIKE Condition

NOT Condition

ALIASES

Joins

BETWEEN Condition

INSERT Statement

INSERT ALL Statement

UPDATE Statement

DELETE Statement

TRUNCATE TABLE Statement

EXISTS Condition

GROUP BY Clause

HAVING Clause

UNION Operator

UNION ALL Operator

INTERSECT Operator

MINUS Operator

Subqueries

PIVOT Clause

Data Types

CREATE TABLE Statement

CREATE TABLE AS Statement

Primary Keys

ALTER TABLE Statement

DROP TABLE Statement

VIEW

Global Temporary tables

LOCAL TEMPORARY TABLES

Foreign Keys

Foreign Keys with cascade delete

Foreign Keys with set null on delete

Drop a foreign key

Disable a foreign key

Enable a foreign key

Unique Constraints

Check Constraints

Indexes

Grant/Revoke Privileges

Synonyms

Roles

CREATE USER statement

Change a user's password in Oracle

DROP USER statement

Find Users in Oracle/PLSQL

Find Users logged into Oracle/PLSQL

Comments within SQL

Literals

Declaring Variables

Sequences (Autonumber)

Functions

Procedures

IF-THEN-ELSE Statement

WHILE LOOP

FOR LOOP

Exit Statement

Loop Statement

REPEAT UNTIL LOOP

GOTO Statement

CURSOR FOR Loop

Named System Exceptions

Named Programmer-Defined Exceptions

WHEN OTHERS Clause

SQLCODE Function

SQLERRM Function

Declare a Cursor

OPEN Statement

FETCH Statement

CLOSE Statement

Cursor Attributes

SELECT FOR UPDATE Statement

WHERE CURRENT OF Statement

BEFORE INSERT Trigger

AFTER INSERT Trigger

BEFORE UPDATE Trigger

AFTER UPDATE Trigger

BEFORE DELETE Trigger

AFTER DELETE Trigger

DROP TRIGGER Statement

Disable a Trigger

Disable all Triggers on a table

Enable a Trigger

Enable all Triggers on a table

CREATE TABLESPACE statement

ALTER TABLESPACE statement

DROP TABLESPACE statement

Find Default Tablespaces (both Permanent and Temp)

Set Default Tablespaces (both Permanent and Temp)

Create a Schema

CREATE SCHEMA statement

COMMIT Statement

ROLLBACK Statement

SET TRANSACTION Statement

LOCK TABLE Statement

Oracle System Tables

Retrieve Oracle version information