SQL*XL: Set command

Set command

Syntax:
SET variable value;

Description:
Sets a program variable.

Variable Description
escape
Sets an escape character so special characters can be escaped from processing. By default escape is off; no escape character is defined. When you switch escape on the default character is \.

Values:
SET escape ON;     Note: the standard escape character is \
SET escape OFF;
SET escape '~';      Note: the escape character is ~

Example:
SET escape '\';
select 'a\&b' from dual;    --Displays a&b. &b is not processed as a bind variable.

feedback Display feedback message how many rows were retrieved in a select statement.
Values:
SET feedback ON;
SET feedback OFF;

long Sets the maximum number of characters (min 1, max 2000000) that will be displayed for columns of data type LongVarchar; Long (Oracle) and Text (SQL Server)

Example:
Set long 100;

timing Displays a message after each query to show the time it took to execute it.
Values:
SET timing ON;
SET timing OFF;

Please note that these settings can also be changed from VBA:

SQLXL.SQLPlus.Feedback = True
SQLXL.SQLPlus.Timing = False

Variable	Description
escape	Sets an escape character so special characters can be escaped from processing. By default escape is off; no escape character is defined. When you switch escape on the default character is \. Values: SET escape ON; Note: the standard escape character is \ SET escape OFF; SET escape '~'; Note: the escape character is ~ Example: SET escape '\'; select 'a\&b' from dual; --Displays a&b. &b is not processed as a bind variable.
feedback	Display feedback message how many rows were retrieved in a select statement. Values: SET feedback ON; SET feedback OFF;
long	Sets the maximum number of characters (min 1, max 2000000) that will be displayed for columns of data type LongVarchar; Long (Oracle) and Text (SQL Server) Example: Set long 100;
timing	Displays a message after each query to show the time it took to execute it. Values: SET timing ON; SET timing OFF;