Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: instance name in SQL Plus prompt?

Re: instance name in SQL Plus prompt?

From: Gildas COTOMALE <gcotomale_at_kleegroup.fr>
Date: Wed, 30 May 2001 10:24:40 +0200
Message-ID: <9f2ahv$dof$1@klin.lan.klee.fr>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US