How to restrict SQLPlus output screen...?

How to restrict select statement output in SQL Plus so that It will wait for user to wait till user hits enter or space to see next page of results / rows... Instead of displaying all in a one shot?

I know about set linesize X but that will split the output after X number of lines but it will display all 100 or 1000 rows in one shot... I need to see or hold first 100 results and then I want to hit enter or space to see next 100 results...
tech-sysAsked:
Who is Participating?
 
Darius GhassemConnect With a Mentor Commented:
You can use "set pause on" then you can make page size "set pagesize 50 or 100 whatever you want"
0
 
Aaron ShiloChief Database ArchitectCommented:
set pause on
0
 
sdstuberCommented:
pipe the output through "more" or a similar utility
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
slightwv (䄆 Netminder) Commented:
I would go with pause but add one more command after the set pause on

set pause 'hit enter to continue...'

otherwise you'll have a blank line
0
 
tech-sysAuthor Commented:
Perfect I followed following steps..... and its working...

Set pause on
Set pagesize 75
0
 
tech-sysAuthor Commented:
Excellent help... Thanks A Lot...
0
 
Aaron ShiloChief Database ArchitectCommented:
i think this isent fair since i gave the same answer first :-(
0
 
slightwv (䄆 Netminder) Commented:
>>Perfect I followed following steps..... and its working...

Bet you money that someday soon, you'll run a query that should take seconds and will wonder why it isn't returning...

It's because pause in 'on' has no prompt.
0
 
slightwv (䄆 Netminder) Commented:
>>i think this isent fair since i gave the same answer first

Not the same.  You didn't post pagesize.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.