Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 771
  • Last Modified:

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...
0
tech-sys
Asked:
tech-sys
  • 3
  • 2
  • 2
  • +2
1 Solution
 
Aaron ShiloChief Database ArchitectCommented:
set pause on
0
 
sdstuberCommented:
pipe the output through "more" or a similar utility
0
 
Darius GhassemCommented:
You can use "set pause on" then you can make page size "set pagesize 50 or 100 whatever you want"
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now