Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: instance name in SQL Plus prompt?
"Daniel A. Morgan" <dmorgan_at_exesolutions.com> a écrit dans le message news:
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
>
No ? I suggest trying to SET his SQLPROMPT to 'testdb' (w/o space) in his LOGIN.SQL file... Received on Wed May 30 2001 - 03:24:40 CDT