Re: Setting the prompt?

John Strange <jstrange_at_imtn.dsccc.com> wrote in message news:7m3f1j$r0e$1_at_relay1.dsccc.com...
> I have SQLPATH pointing to a directory of common *.sql files.
> One of them is login.sql which sqlplus executes by default. It contains
> This will set the prompt on the first connect.
.... [code deleted]
> In you example of the second connect, I would do the connect then a
> @login.sql to set the prompt to the new_user_at_where_ever.
First, thanks for the bit of code and the reply. We already have a script which executes automatically when we first launch sqlplus.
I also believe that we can change the prompt manually via a similar (perhaps same?) sql script -- I'm only the Jr. DBA, I didn't create the script. We were looking for a way to do it automatically. It's an added step for users and if they forget and think they're on the old database, that could be trouble (as it already has been).

Be nice if Oracle could add some functionality that would do this automatically, without need of running a SQL script every time you connect to a new database.

Mark Received on Fri Jul 09 1999 - 10:24:10 CDT