Basic statements (PL/SQL)

The programming statements that can be used in a PL/SQL application include: assignment, DELETE, EXECUTE IMMEDIATE, INSERT, NULL, SELECT INTO, and UPDATE.

NULL statement (PL/SQL)
The NULL statement is an executable statement that does nothing. The NULL statement can act as a placeholder whenever an executable statement is required, but no SQL operation is wanted; for example, within a branch of the IF-THEN-ELSE statement.
Assignment statement (PL/SQL)
The assignment statement sets a previously-declared variable or formal OUT or IN OUT parameter to the value of an expression.
EXECUTE IMMEDIATE statement (PL/SQL)
The EXECUTE IMMEDIATE statement prepares an executable form of an SQL statement from a character string form of the statement and then executes the SQL statement. EXECUTE IMMEDIATE combines the basic functions of the PREPARE and EXECUTE statements.
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.
BULK COLLECT INTO clause (PL/SQL)
A SELECT INTO statement with the optional BULK COLLECT keywords preceding the INTO keyword retrieves multiple rows into an array.
RETURNING INTO clause (PL/SQL)
INSERT, UPDATE, and DELETE statements that are appended with the optional RETURNING INTO clause can be compiled by the Db2 data server. When used in PL/SQL contexts, this clause captures the newly added, modified, or deleted values from executing INSERT, UPDATE, or DELETE statements, respectively.
Statement attributes (PL/SQL)
SQL%FOUND, SQL%NOTFOUND, and SQL%ROWCOUNT are PL/SQL attributes that can be used to determine the effect of an SQL statement.

Parent topic: PL/SQL support