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
Share this Page URL
Help

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 /:


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint