Re: change sqlprompt at the time of switching user

On 2 Apr 2007 19:27:25 -0700, "peter" <hhh.database_at_gmail.com> wrote:

>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

Tom Kyte, in one of his books (I think the first one) talks about @connect.sql script that does this

Might find references on his site as well asktom.oracle.com
.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Tue Apr 03 2007 - 10:28:13 CDT