Syntax:
SHOW variable;

Description:
Displays the value of a program variable.

Variable	Description
escape	Shows the value of the escape character.
feedback	Display the value of the feedback program variable (ON/ OFF); When feedback is on a line below queries data is printed with the number of retrieved rows.
long	Display the value of the long program variable. It 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)
timing	Displays the value of the timing program variable. A message after each query to show the time it took to execute it.

See also:

• Commands
• SQL*XL Home
• Features