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:
- SELECT Statement
- DISTINCT
- COUNT / SUM / MIN / MAX
- WHERE Clause
- "AND" Condition
- "OR" Condition
- Combining "AND" with "OR"
- "LIKE" Condition
- "IN" Function
- BETWEEN Condition
- EXISTS Condition
- GROUP BY
- HAVING
- ORDER BY (sort by)
- JOINS (inner, outer)
- Subqueries
- UNION Query
- UNION ALL Query
- INTERSECT Query
- MINUS Query
- UPDATE Statement
- INSERT Statement
- DELETE Statement
- Tables (create, alter, drop, temp)
- Views
- Data Types
- Literals (Constants)
- Declaring Variables
- Is Null / Is Not Null
- Loops and Conditional Statements
- Sequences (Autonumber)
- Transactions
- Cursors
- Functions (Built-In) (By Category)
- Functions (Built-In) (Alphabetical)
- Oracle System Tables
- Primary Keys
- Foreign Keys
- Unique Constraints
- Check Constraints
- Indexes
- Creating Functions
- Creating Procedures
- Creating Triggers
- Exception Handling
- Oracle Error Messages
- Grant/Revoke Privileges
- Roles (set of privileges)
- Change Password
- Synonyms (create, drop)
- Question & Answer