Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Commands

Buy now

Download now

SQL*XL online help
 

SQL*XL: Set command

Set command

SQL*XL
home

Syntax:
SET variable value;

Description:
Sets a program variable.

VariableDescription
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.

feedbackDisplay 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;
timingDisplays 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


See also:

SQL*XL ribbon in Excel