query

I have a long query which is beign scrolled over for 10 pages..
is there any way to display page by page
nobleitAsked:
Who is Participating?
 
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.

All Courses

From novice to tech pro — start learning today.