SQL (Structured Query Language) Question:
Download Questions PDF

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

Answer:

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.

Download SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What is explain plan and how is it used?How do you prevent output from coming to the screen?