If I may add a suggestion to what Mr. Bobak had to say:
I have a connect.sql script in the same directory as the login.sql script.
The connect.sql script has the following lines:
connect &1 &2 &3
@@login
The reason I have "&2" and "&3" parameters is to be able to say
@connect sys/password as sysdba
> -----Original Message-----
> From: Mark J. Bobak [mailto:[EMAIL PROTECTED]]
>
> ...
> Anyhow, one work around I have seen is:
> Create conn.sql
> put 'connect &1' as the first line
> add in the lines from glogin.sql that set the prompt
>
> Then, when you switch connections, get in the habit of typing '@conn
> ...' instead of 'conn ...'.
>
> On Sat, 2002-10-26 at 01:58, [EMAIL PROTECTED] wrote:
> > We want to set the sql promp as username@database >
> > We set this in Glogin.sql as :
> >
> > column global_name new_value gname
> > select user||'@'||host_name global_name from
> v$instance,global_name;
> > set sqlprompt '&gname>'
> >
> > We are able to get this prompt when we login to sql for
> the first time .
> > When we change connection at the prompt using connect
> statement we are not
> > able to get the new user name and database as prompt
> >
> > eg :
> > RR@BKP>conn test/test@o8
> > Connected.
> > RR@BKP>
