Answers

Question and Answer:

  Home  SQL

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

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.

 170 views

More Questions for you: