set blockterminator [SQL*Plus]

SQL> set blockterminator c
SQL> set blockterminator on 
SQL> set blockterminator off 

The blockterminator is the character that terminates a PL/SQL block. With set blockterminator, it is possible to specify that character. The default is a dot (.). The character can not alpha numeric. set blockterminator on sets the blockterminator to the dot.

In the following example, I set the blockterminator to an exclamation mark. Then I start entering a PL/SQL block (declare...begin) until I enter the ! on a line by itself. This stops entering the PL/SQL block.

SQL> set blockterminator !
SQL> declare
  2    a number;
  3    b number;
  4  begin
  5  !
SQL>

set, set sqlblanklines, set sqlterminator

SQL*PLus