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.