Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

SET SPACE — Obsolete

Synopsis

The SPACE setting, an obsolete setting, is similar to SET COLSEP. It allows you to specify the number of spaces SQL*Plus prints between columns of output.

Syntax

SET SPACE num_of_spaces

Parameters

num_of_spaces

Is the new setting for the number of spaces you want to print between columns. The default setting is one space.

Examples

The following example shows how SET SPACE works by changing the spacing between columns from one to five spaces:

SQL> SELECT 'A' a, 'B' b FROM dual;
A B
- -
A B
SQL> SET SPACE 5
SQL> SELECT 'A' a, 'B' b FROM dual;
A     B
-     -
A     B

Issuing SET SPACE 5 has the exact same effect as issuing SET COLSEP " " (with five spaces). In fact, the two settings are kept in sync with one another. The SET SPACE command will change the COLSEP setting to match.