SQL statements that are supported within PL/SQL contexts can be used to modify data or to specify the manner in which statements are to be executed.
Command | Description |
---|---|
DELETE | Deletes rows from a table |
INSERT | Inserts rows into a table |
MERGE | Updates a target (a table or view) using data from a source (result of a table reference) |
SELECT INTO | Retrieves rows from a table |
UPDATE | Updates rows in a table |