use

set pages 10

to change the page to 10 lines.

John

--- Nikunj Sharma <nikunj.[Email Address Removed] 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] Sent: 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] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit 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 documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit 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
>


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
Oracle LazyDBA home page