Re: Changing your SQL*Plus prompt to the instance name

On Tue, 14 Jul 1998 12:26:00 +0300, "janne" <janne.laurila_at_orion.fi> wrote:

>How can I do that?
>
>t. janne
>
>

Create a file say, prompt.sql include the following code snippet....

Rem Create _DB_Name variable for general use. set termout off
column upper(VALUE) new_value _DB_NAME; select upper(value)
from v$parameter
where upper(name) = 'DB_NAME';
rem
rem Put SGA Name in sql prompt
set SQLPROMPT '&_DB_NAME.> '
rem
clear breaks
set termout on
set feedback on

And then execute prompt.sql from your login.sql file

Thanks to K.Atkins.... Received on Tue Jul 14 1998 - 05:42:47 CDT