how to make sql prompt like USER@DATABASE> ?

[Salaheldin Aboali]

hi how to make sql prompt like USER@DATABASE> ? where USER: connected user DATABASE: database global name, or database local alias Regards, Salaheldin Aboali ------------------------------------------- Senior Software Developer Management Information Systems http://www.mis-kuwait.com Phone: +965.240.64.25 +965.240.67.98 +965.240.80.92 Ext. 235 Fax. +965.240.81.53 Cell. +965.790.31.65