• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

query

I have a long query which is beign scrolled over for 10 pages..
is there any way to display page by page
0
nobleit
Asked:
nobleit
1 Solution
 
MrNedCommented:
I assume you mean in SQL*Plus - use the SET PAUSE ON command before running your query. It will prompt for a keypress on each page.

Other commands available here: http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12040.htm#sthref2520
0
 
slightwv (䄆 Netminder) Commented:
I agree with PAUSE.

I wanted to add that you should also set PAGESIZE

and, create a 'prompt' to show you are PAUSED:  set PAUSE 'Hit enter to continue...'

If you forget the prompt, some day, you will forget and the screen will just sit there.
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now