Re: Assigning the SQL PROMPT
From: Bradley W Howerter <howerter_at_world.std.com>
Date: Tue, 7 Mar 1995 13:48:22 GMT
Message-ID: <D52p0M.6BM_at_world.std.com>
Date: Tue, 7 Mar 1995 13:48:22 GMT
Message-ID: <D52p0M.6BM_at_world.std.com>
TRBER2_at_CPVMA.sr.chevron.com writes:
>Is there a way to dynamically set the SQL PROMPT in SQL PLUS depending on
>which line of my CONFIG.ORA is active.
>I prefer to not have several different LOGIN.SQL's each
>with a different SET SQLPROMPT command. Thanks in advance.
Here is a login.sql that does the trick (you'll probably want to change the parameter, though):
column async noprint new_value async_prompt;
set heading off;
select decode(value,'TRUE','ASYNC','NOASYNC') async from v$parameter
where name = 'async_write';
set heading on;
set sqlprompt "&async_prompt SQL> "
column async clear
bhower_at_wgc.woodward.com Received on Tue Mar 07 1995 - 14:48:22 CET