SELECT Data Retrieval. Retrieves Data from the database


INSERT Data manipulation language (DML). Enter new rows, changes existing rows,
UPDATE and removes unwanted rows from tables in the database, respectively.
DELETE Collectively known as data manipulation language (DML).
MERGE

CREATE Data definition language (DDL). Setups, changes, and removes data
ALTER structure from tables. Collectively known as data definition language)
DROP (DDL)
RENAME
TRUNCATE

COMMIT Transaction Control. Manages the changes made by DML statements.
ROLLBACK Changes to the data can be grouped together into logical transactions.
SAVEPOINT

GRANT Data Control language (DCL). Gives or removes access rights to both the
REVOKE Oracle database and the structures within it. Collectively known as data
control language (DCL)