SQL Interview Question:

How do you set the number of lines on a page of output? The width?

Submitted by: Administrator

The SET command in SQLPLUS is used to control the number of lines generated per page and the width of those lines, for example SET PAGESIZE 60 LINESIZE 80 will generate reports that are 60 lines long with a line width of 80 characters. The PAGESIZE and LINESIZE options can be shortened to PAGES and LINES.
Submitted by: Administrator