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
Previous Topic: Re: how to display only limited no of rows at a time
Next Topic: UTL_FILE
Goto Forum:
  


Current Time: Thu Sep 23 13:00:00 CDT 2021