Home » SQL & PL/SQL » SQL & PL/SQL » Re: how to display only limited no of rows at a time
Re: how to display only limited no of rows at a time [message #484] Thu, 14 February 2002 23:53
Mike
Messages: 417
Registered: September 1998
Senior Member
If you are using SQL*Plus you can use the PAUSE option.
SET PAUSE ON
If you should use another tool then SQL*Plus please say which one it is.

I don't recommand you to do anything with the pseudocolumn ROWNUM because for each set of 10 rows the entire query will be reexecuted.

HTH
Mike

Report message to a moderator

Previous Topic: Re: how to display only limited no of rows at a time
Next Topic: UTL_FILE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 16 14:42:41 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.