UNIX-like prompt in SQL*PLUS

Dear oraculars,

I sometimes get confused when I have several SQL*PLUS sessions open, some connected to different instances on one host, some connected to a specific SQL*NET service.

I would like to have the database/service that I'm connected to displayed in the SQL*PLUS prompt, like having the UNIX host name displayed in, say, the ksh prompt.

Do you see a way of bringing the output of "select * from global_name" into the SQL*PROMPT, ideally whenever I do a new "connect"?

When answering, please do a "CC" to Thomas.Meyer_at_dla-marbach.de

Regards,

--

	Thomas Meyer, EDV-Systemadministrator
	  email: Thomas.Meyer_at_dla-marbach.de
	  smail: Deutsches Literaturarchiv Marbach
		 Schillerhoehe 8-10
		 D-71672 Marbach
	Telefon: +49-7144-848-141
	    Fax:          ...-387
	    WWW: http://www.dla-marbach.de