Re: Enhancement SQL*Plus (prev.: Re: Fixing a little problem in the login.sql script found in Tom Kyte's book)

On 15 Jan 2003, yf110_at_vtn1.victoria.tc.ca wrote:

> set prompt can be used to show your USER/DBNAME/SID, but if you change
> the database to which you are connected and forget to run the set
> prompt command then the prompt will be misleading.

Have a conn.sql in your SQLPATH which runs conn XX/YY_at_ZZ and then runs the query which sets your sqlprompt.

Then, never run
  SQL> conn XX/YY_at_ZZ
but instead run
  SQL>@conn XX/YY_at_ZZ

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.