Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Chapter 5. Using SQL*Plus > Setting the Page Size
Setting the Page Size
You set the number of lines in a page using the SET PAGESIZE command. This command sets the number of lines that SQL*Plus considers one “page” of output, after which SQL*Plus will display the headings again.
Set the page size to 100 lines using the following SET PAGESIZE command and run your query again using /:
