|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
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.
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>