Home » SQL & PL/SQL » Client Tools » scroll page-wise in SQL Plus
scroll page-wise in SQL Plus [message #267426] Thu, 13 September 2007 04:45 Go to next message
beetel
Messages: 96
Registered: April 2007
Member
How do I scroll page-wise in SQL Plus? Let's say my query returns 1000 rows but I would like to see them 50 rows at a time per page.. Please help..
Re: scroll page-wise in SQL Plus [message #267429 is a reply to message #267426] Thu, 13 September 2007 04:50 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

USE SET PAGESIZE command.

For more reference see the link SQL*PLUS Commands

Cheers
Soumen
Re: scroll page-wise in SQL Plus [message #267443 is a reply to message #267429] Thu, 13 September 2007 05:16 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Combine the pagesize with SET PAUSE
Previous Topic: SQL * PLUS
Next Topic: how to open my sql editor in browser
Goto Forum:
  


Current Time: Sun Dec 04 18:44:38 CST 2016

Total time taken to generate the page: 0.09320 seconds