Re: set pause on

So... you should limit your row count. Add where rownum <= x;

If you have to see the whole table get a tool like toad. You can get a free and scaled down version for free from qwest software.

"Sanjay Raj" <rsanjaynj_at_yahoo.com> wrote in message news:9f767483.0203180539.2d7f0f27_at_posting.google.com...
> "justme" <someq_at_rogers.com> wrote in message
 news:<NoAj8.6698$lM.5233_at_news2.bloor.is>...
> > spool the results to a file.
> >
> > "Carmela" <carmela_wong_at_hotmail.com> wrote in message
> > news:bf915686.0203121614.32bc2374_at_posting.google.com...
> > > Hi folks !
> > >
> > > This is really strange. When I issue a set pause on in Oracle 9i, it
> > > does not mind. But when I run a select query after that hoping to see
> > > a pagewise display, Oracle just closes down rudely as though I had
> > > issued a quit. Does anyone have a solution ? Has this happened with
> > > anyone else too ?
> > >
> > > Please help urgently as I am unable to see any data in the database
> > > except the last few records where the scrolling stops when I have not
> > > issued set pause on.
> > >
> > > Thank you very much.
> > > Carmela
>
> Please go to SQLPLUS and type SHOW ALL. This will list all the SET
> commands presently enabled. Check if U have something set like SET
> TERMOUT OFF which is preventing Oracle to display the results.DO U get
> the results when u set PAUSE OFF?
>
Received on Fri Apr 05 2002 - 19:36:15 CEST