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 9iIt 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