Re: change sqlprompt at the time of switching user

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Tue, 03 Apr 2007 02:36:11 GMT
Message-ID: <v4jQh.144285$6P2.96962@newsfe16.phx>

"peter" <hhh.database_at_gmail.com> wrote in news:1175567245.924424.48100 @l77g2000hsb.googlegroups.com:

> When I connect to sqlplus initially, I can set sqlprompt(using
> glogin.sql). But when I switch user in between, it is not changing
> sqlprompt. Is there any way to change sqlprompt at that time also.
> Like we can do that in 10g.
> Database : 9.2.0.8
> OS : Sun Solaris/ Windows XP
>
>

Please note the file name; gLOGIN.sql
It is invoked only upon initial LOGIN.

>Is there any way to change sqlprompt at that time also.
Create a sql script that does both; chane user & change prompt. Received on Mon Apr 02 2007 - 21:36:11 CDT