use
SQL > Set Pause On


It will show the output page by page but i don't know if you can set the
limit to 10
by this data will not be scrolled and you will able to data by pressing
enter key.

Nikunj

-----Original Message-----
From: Randhir.Singh [mailto:Randhir.[Email Address Removed] Friday, May 31, 2002 5:36 PM
To: LazyDBA.com Discussion
Subject: show 10 lines then again 10 lines


hi ganesh,
is there any query like,which works like dos commnad "dir *.rtf |more".
this command show one full screen data & then by pressing any key
show next full screen data.
or
is there any query to see first 10 rows & then next 10 & so on...

with regards
randhir

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page