On Thu, May 21, 2009 at 8:24 AM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx>wrote: > Jared, > > > > Starting in 10g, you can do: > > Set sqlprompt “_user’@’_connect_identifier> “ > > And it will stay up to date across multiple ‘connect’ operations. > > > Thanks Mark, I do recall that. It is another example of 'tool little too late' I already had a method to deal with it. Exiting sqlplus to make a new connection is actually simpler, at least for me. This how curmudgeons are created. "I crafted a solution to that problem years ago, and 10 years later they come out with a solution?" Bah, humbug! :) Jared