ESCAPE
ESC[APE] c | ON | OFF
					

Defines the character to use as the escape character, which indicates that SQL*Plus should treat a substitution character as an ordinary character rather than as a request for variable substitution.

Keywords

c

Changes the value of the escape character to this character.

ON

Changes the value of the escape character back to the default backslash ("\"), and enables the escape feature.

OFF

Turns off the escape feature. This option is the default.

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.