Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL Plus and the SQL prompt...
This is great except the file only gets read when you open sqlplus.
could it be changed so that once you have opened and connect and you then connect to another machine that is refreshes itself automatically.
thx
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:968178007.2385.0.pluto.d4ee154e_at_news.demon.nl...
> easy
> column global_name new_value dbnam
> select global_name from global_name;
> set sqlprompt &dbnam.>
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
> "Sean" <dolans_at_my-deja.com> wrote in message
> news:8p38m5$tms$1_at_nnrp1.deja.com...
> > Oracle 8i on Windows Nt, connecting to it via SQL PLUS.
> >
> > Is it possible to have the prompt be something else besides "SQL>" ?
> > For example, the name of the instance of the machine you are connecting
> > to? If so, any directions would be greatly appreciated.
> >
> > Thanks,
> > Sean
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Wed Sep 06 2000 - 00:51:31 CDT