Hi,
If you give set pau on lines 10
select blah,blah from table
it would show 10 lines and then enetr again would show
10 lines.

Cheers,
John.


--- "Randhir.Singh" <Randhir.[Email Address Removed] > hi nikunj,
> by set pause on 11 rows are shown at a time.
> or approx 11 lines u can say.
> send you comment pls. am i write.
> u can chech it on one 2 -3 fields table & more than
> that fields table.
> i'm just telling this on practical basis.
>
> bye!!
> Randhir
>
> -----Original Message-----
> From: Nikunj Sharma
> [mailto:nikunj.[Email Address Removed] Sent: Friday, May 31, 2002 11:57 AM
> To: LazyDBA.com Discussion
> Subject: RE: show 10 lines then again 10 lines
>
>
> 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
>
>
> --------
> 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!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
Oracle LazyDBA home page