Oracle-L: Re: sqlplus prompt question in 9i

From: <Jared.Still_at_radisys.com>
Date: Wed, 29 Oct 2003 09:14:26 -0800
Message-ID: <F001.005D4F36.20031029091426@fatcity.com>

You could just use login.sql instead, on a per user basis.

If you don't want login.sql to be used, just edit or unset SQLPATH.

Maybe other options available for this in 9i. A perusal of the sqlplus manual may prove useful.

Jared

"Guang Mei" <gmei_at_incyte.com>
Sent by: ml-errors_at_fatcity.com
10/29/2003 08:24 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        sqlplus prompt question in 9i

Hi:

With Oracle 8i, I always modified $ORACLE_HOME/sqlplus/admin/glogin.sql, and
added

set termout off
col site_name noprint new_value site_name_new select 'SQL> ' site_name from dual;
select user

       || substr(proc.program, instr(proc.program,'@'),
                 instr(proc.program,' ') - instr(proc.program,'@'))
       || '-SQL> ' site_name

from v$process proc
where proc.pid = 2;
set sqlprompt '&&site_name_new'
set termout on

so that when a user launches sqlplus, it would show something at prompt like

username_at_hostname-SQL>

instead of

SQL> I found that doing this in 9i will prevent me starting up my instance, when
I use

sqlplus '/as sysdba'

In 8i, I always used svrmgrl to bounce db so there was no problem with modified glogin.sql.

Has anyone found a work-around in 9i so that sqlplus prompt displays "username" and "hostname" when launched? I know there is a new _CONNECT_IDENTIFIER in 9i, but that's not good enough.

TIA. Guang

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Guang Mei
INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------