SQL*Plus Line Break Control Guide

1 year ago
Emily Johnson
1 minute

In SQL*Plus, you can use the SET PAGESIZE and SET LINESIZE commands to control the number of lines for line breaks and the number of characters per line.

For example, to set the number of rows displayed per page to 20 rows, you can use the following command:

SET PAGESIZE 20;

To set the number of characters displayed per line to 80 characters, you can use the following command:

SET LINESIZE 80;

This way, you can control the line break format of the SQL*Plus output.

bannerAds