Re: SQLPLUS - Unwanted Pause
From: Malakhov Nikolay <mal_at_kpbank.ru>
Date: 1997/05/30
Message-ID: <338E7B66.B07_at_kpbank.ru>#1/1
Date: 1997/05/30
Message-ID: <338E7B66.B07_at_kpbank.ru>#1/1
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
Received on Fri May 30 1997 - 00:00:00 CEST