Re: SQLPROMPT in Sql*Plus
From: Zbrk <zivjeli_at_veselili.se>
Date: Mon, 24 Jun 2002 08:40:51 +0200
Message-ID: <af6eu4$h5p8_at_ns4.bih.net.ba>
Date: Mon, 24 Jun 2002 08:40:51 +0200
Message-ID: <af6eu4$h5p8_at_ns4.bih.net.ba>
Hi Bliss
Thank you very much this is the solution I asked for, but when I use connect username/password_at_alias from Sql*Plus the sqlprompt doesn't change to the right value. Is there a solution for that.
Thanx again
Bliss <ignorance_is_bliss_at_123india.com> wrote in message
news:3d13f67a_1_at_news.tm.net.my...
> hi,
>
> try including this in your login.sql
>
> column a1 new_value prmpt
> set termout off
> select name || '> ' a1 from v$database;
> set termout on
> set sqlprompt "&&prmpt"
> undef prmpt
>
> hope this helps...
>
> regards,
> bliss
>
Received on Mon Jun 24 2002 - 08:40:51 CEST