NULL

Syntax

A NULL statement, as its name suggests, does nothing. It can be useful as a placeholder to mark a place in the code or to indicate that nothing is to occur in those branches of an IF statement where it is placed (similar to adding "This page intentionally left blank" in a document).

NULL;

Example

Using a NULL statement as part of an IF statement:

IF NOT output_was_written THEN
  DBMS_OUTPUT.PUT_LINE( ‘Some output’ );
  output_was_written := TRUE;
ELSE
  ---
  --- We do nothing if the output was already written.
  ---
  NULL;
END IF;