Re: change sqlprompt at the time of switching user

On 3 apr, 11:52, "gazzag" <gar..._at_jamms.org> wrote:
> On 3 Apr, 03:36, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> [deletia]
>
> > Please note the file name; gLOGIN.sql
> > It is invoked only upon initial LOGIN.
>
> It seems to me that someone better go back to tahiti.oracle.com and re-
> read every every manual located athttp://tahiti.orcle.com. According to the documentation here,http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14357/ch1...,
> "Glogin/login files are called for each reconnect."
>
> E.g.
>
> SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 3 10:37:56 2007

[--]
>
> Peter, include the following line in your $ORACLE_HOME/sqlplus/admin/
> glogin.sql file:
>
> SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER > "
>
> Also note the line in the documentation that states: "It is
> recommended that you add SET SQLPLUSCOMPATIBILITY 10.2.0 to your
> scripts to maximize their compatibility with future versions of
> SQL*Plus."
>
> HTH
>
> -g

iirc, this is a change between the 10GR1 and the 10GR2 client - the 9 or 10GR1
clients did *not* read the glogin.sql every time... You use the 10gR2 client, hence your ability to do what you do. Received on Tue Apr 03 2007 - 09:14:44 CDT