How do you set the output length in sqlplus?

2 years ago

Ava Mitchell

1 minute

In SQL*Plus, you can use the SET command to adjust the length of output columns.

To set the length of the output column, you can use the following command:

SET COLSEP |

The vertical line character “|” is used to separate each column of the output.

Next, you can use the following command to set the length of each column:

SET LINESIZE n

Where n is an integer indicating the length of each line.

For example, to set the length of each column to 20 characters, you can use the following command:

SET LINESIZE 20

In this way, SQL*Plus will automatically truncate or pad each output column to a length of 20 characters.