Re: set pause on

carmela_wong_at_hotmail.com (Carmela) 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 ?

Oracle9 documentation for SQL*Plus says SET PAUSE in no longer supported.

>
> 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.

You can try SQLPlus Worksheet that comes with Oracle. You can scroll through the output to see the first records.

>
> Thank you very much.
> Carmela

Andrey Received on Tue Mar 19 2002 - 00:20:38 CET