Oracle SQL

select

DCL statements: grant and revoke

DDL statements: analyze, associate statistics, audit, comment, create ..., disassociate statistics, drop ... , flashback ... , grant, noaudit, purge, rename, revoke, truncate

DML statements: call, delete, explain plan, insert, lock table, merge, select and update.

TCL statements: commit, savepoint, rollback, set transaction

datatypes

Oracle SQL functions

SQL statement execution

Oracle SQL: Session and system control statements

In order to dynamically execute SQL statements (that are for example stored in a string), execute immediate might be used.

Cursors