RE: sqlplus prompt question in 9i

[Guang Mei]

Title: RE: sqlplus prompt question in 9i

Thanks David!

 

That's exactly what I am looking for.

 

Guang

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of david hill
Sent: Thursday, October 30, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: sqlplus prompt question in 9i

It could be your sql
Here is the prompt I have been using for a while with no problems at all
If the db is down you get a prompt of
Nolog>

set termout off
    define new_prompt='nolog'
    column value new_value new_prompt
    select SYS_CONTEXT('USERENV', 'SESSION_USER') || ':' ||SYS_CONTEXT('USERENV', 'DB_NAME') value
        from dual;
    set sqlprompt "&new_prompt> "
set termout on