Explain the way to set number of lines on a page of output

Question

Explain the way to set the number of lines upon a page of output and the width.

Answer 1

The SET command within SQLPLUS is employed to control the number of lines produced per page and the width of such lines, for illustration SET PAGESIZE 60 LINESIZE 80 will produce reports which are 60 lines long along with a line width of 80 characters. Therefore, the PAGESIZE and LINESIZE options both can be shortened to LINES and PAGES.