SQL statements (PL/SQL)

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.

Table 1 lists these statements. The behavior of these statements when executed in PL/SQL contexts is equivalent to the behavior of the corresponding Db2® SQL statements.

Table 1. SQL statements that can be executed by the Db2 data server within PL/SQL contexts
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