Oracle/PLSQL Topics

Oracle is a relational database technology.

PLSQL stands for "Procedural Language extensions to SQL", and can be used in Oracle databases. PLSQL is closely integrated into the SQL language, yet it adds programming constructs that are not native to SQL.

We've categorized Oracle and PLSQL into the following topics:

Data Types SELECT Statement
Literals (Constants) DISTINCT
Declaring Variables COUNT / SUM / MIN / MAX
Is Null / Is Not Null
WHERE Clause
Loops and Conditional Statements "AND" Condition
Sequences (Autonumber) "OR" Condition
Transactions Combining "AND" with "OR"
Cursors
Functions (Built-In) (By Category) "LIKE" Condition
Functions (Built-In) (Alphabetical) "IN" Function
Oracle System Tables BETWEEN Condition
EXISTS Condition
Primary Keys GROUP BY
Foreign Keys HAVING
Unique Constraints ORDER BY (sort by)
Check Constraints
Indexes JOINS (inner, outer)
Subqueries
Creating Functions
Creating Procedures UNION Query
Creating Triggers UNION ALL Query
Exception Handling INTERSECT Query
Oracle Error Messages MINUS Query

Grant/Revoke Privileges UPDATE Statement
Roles (set of privileges) INSERT Statement
Change Password DELETE Statement

Synonyms (create, drop) Tables (create, alter, drop, temp)