- Aggregates and Sets
- ANY, ALL, IN, EXISTS, UNIONS
- GROUP BY
- HAVING
- NULLs
|
- Complex Queries
- Dataset Windows
- Pipelined DML
- Scalar Functions
- Temporal Features
- XML Features
|
- DDL and DCL
- Access Rights
- Indexes and Constraints
- Tables and Table Structure
- Triggers
- Views
|
- Data Modification
- DELETE
- INSERT
- UPDATE
- View Data Update
|
- Multi-Table Queries
- FULL OUTER JOIN
- INNER JOIN
- LEFT/RIGHT OUTER JOIN
- Self Joins
|
- Queries
- Access to Table Data
- Constants and Comments
- DISTINCT
- Equality Predicates
- Filtering and Sorting
|
- SQL/PSM
- Cursors
- Exception Handling
- Flow Control
- Variables
- Writing SQL Modules
|
- Subqueries
- Correlated
- Row Deletion
- Single Value
- Subquery Based Updates
|
- Transaction Control
- Beginning Transactions
- COMMIT
- Nested Transactions
- ROLLBACK
- Savepoints
|
- Tuning and Debugging
- Explain Statements and Plans
- Improving Query Performance
- Recognizing Full Table Scans
- Resolving Query Errors
|