Re: instance name in SQL Plus prompt?

From: Dan A. <nospam_at_email.com>
Date: Tue, 29 May 2001 12:58:41 -0700
Message-ID: <9f0v1i$p51$1@nntp.Stanford.EDU>

Thanks! Those suggestions worked great!

"bryan munday" <bardy_at_MailAndNews.com> wrote in message news:3B209BBB_at_MailAndNews.com...
> This works as a login.sql for VMS, can' see why similar wouldn;t wiork in
> Windoze:
>
> col name new_value db_name
> set term off
> select name
> from v$database
> ;
> set term on
> set sqlprompt '&DB_NAME.> '
>
> Regards
>
> BRyan
>
> >Daniel A. Morgan <dmorgan_at_exesolutions.com> schrieb in im Newsbeitrag:
> >3B0DFC51.615A694F_at_exesolutions.com...
> >> "Dan A." wrote:
> >>
> >> > Hi - Does anyone know how to put the current instance name in the sql
plus
> >> > prompt? I'm using the windows (2000) version of sqlplus. Instead
of
the
> >> > default:
> >> >
> >> > SQL>
> >> >
> >> > can it be changed to something like:
> >> >
> >> > TESTDB>
> >> >
> >> > and it would always change to whatever instance you login to?
> >> >
> >> > Thanks in advance! -Dan
> >>
> >> No.
> >>
> >> Daniel A. Morgan
> >>
> >
>
> ------------------------------------------------------------
> Get your FREE web-based e-mail and newsgroup access at:
> http://MailAndNews.com
>
> Create a new mailbox, or access your existing IMAP4 or
> POP3 mailbox from anywhere with just a web browser.
> ------------------------------------------------------------
>
Received on Tue May 29 2001 - 14:58:41 CDT