CMDSEP
CMDS[EP] {c | ON | OFF} 

Sets the character used to separate multiple SQL*Plus commands entered on one line.

Keywords

c

Specifies the character (which must not be alphanumeric) used to separate SQL*Plus commands. The default is a semicolon (;).

ON

Turns on the ability to enter multiple commands on one line and automatically sets the command separator character to a semicolon (;).

OFF

Turns off the ability to enter multiple commands on a line.

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.