sqlplus prompt

For sql*plus i would like to use a login.sql that changes the prompt. When i connect like: connect scott/tiger_at_sales
The sqlplus prompt would be:
scott_at_sales>
When i start another sqlplus session like: connect system/manager_at_people
The prompt would be:
system_at_people>
Both sqlplus sessions will use the same login.sql So the contents of the prompt should be determined
dynamically.
I don't know how to achieve this, so if anyone has a good suggestion i would highly appreciate it.
I use sqlplus on a win'95 desktop, the databases can be on unix or win-nt servers.

Thanks in advance,
Hans Schoorlemmer
Email : hschoorl_at_pi.net Received on Fri Dec 13 1996 - 00:00:00 CST