SET ESCAPE

Syntax

SET ESCAPE <C>|ON|OFF;

Description

Specifies the escape character, which makes it possible to input special characters like &. <C> must relate to one single special character. You can activate/deactivate the escape character by using SET ESCAPE ON|OFF. When setting a character, it is activated automatically. In default case, the escape character is \, but it is deactivated.

Examples

SQL_EXA> define value=a;
SQL_EXA> prompt $&value;

SQL_EXA> set escape $;
SQL_EXA> prompt $&value;