Home » Other » 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..

Report message to a moderator

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

Report message to a moderator

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: 7901
Registered: March 2000
Senior Member
Combine the pagesize with SET PAUSE

Report message to a moderator

Previous Topic: SQL * PLUS
Next Topic: how to open my sql editor in browser
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 11 07:35:24 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.