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
Example To set the linesize for the output to 30, enter SQL> SET LINESIZE 30 SQL> SHOW LINESIZE linesize 30
To dynamically change the output display after manually resizing the screen, enter
SQL> SET LINESIZE Window SQL> SHOW LINESIZE linesize 210 WINDOW
Note:
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: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
Anuradha’s LinkedIn: Anuradha’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
