Re: SQL Plus and the SQL prompt...

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 5 Sep 2000 19:44:52 +0200
Message-ID: <968178007.2385.0.pluto.d4ee154e@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 Tue Sep 05 2000 - 12:44:52 CDT