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

From: Al <al_at_work>
Date: Thu, 16 Jul 1998 13:32:59 -0400
Message-ID: <6oldij$m7i2@piper.ncr.pwgsc.gc.ca>

This stuff can also be put in the glogin.sql script that is found in $ORACLE_HOME/sqlplus/admin (Unix) or ORACLE_HOME/plus33 (NT).

This will set the prompt for all users.

Huwski wrote in message <35ab35bd.12679963_at_news.geccs.gecm.com>...
>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 Thu Jul 16 1998 - 12:32:59 CDT