Sets the total number of characters that SQL*Plus displays on one line before beginning a new line.

WINDOW adjusts the linesize and pagesize for the formatted output according to the width and height of the screen. If the output is longer than the screen width, then the output is wrapped accordingly

To dynamically change the output display after manually resizing the screen, enter

The SET LINESIZE WINDOW command is ignored in a script and the output will not be displayed according to the screen size.

Reference SQL*Plus User’s Guide and Reference

Stay Tuned for More Information on Oracle 18c

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply