Re: SQLPLUS - Unwanted Pause

Malakhov Nikolay <mal_at_kpbank.ru> wrote:

>Ron Strouss wrote:
>>
>> We have a select statement on the v$database table to get the
>> database name which will be used as part of the user's SQLPLUS Prompt.
>
>Hi! may be this will help - part of my login.sql:
>col sqlprompt new_value ppp noprint
>set pause off
>set termout off
>select global_name||'>_' sqlprompt from global_name;
>set sqlp &ppp
>set pause on
>set term on

Malakhov Nikolay

We can set pause off ... and we can run your version of the glogin script and it still pauses if you do any kind of 'select' statement ... ???

Ron Received on Fri May 30 1997 - 00:00:00 CEST