Setting prompt in SQL*Plus

From: Ng TC <tcng_at_yas.com.sg>
Date: 25 Apr 1998 06:42:23 GMT
Message-ID: <01bd7015$7e865980$ebce2aca@mis1-235.yas.com.sg>

Hi,

I read somewhere that the following (when included in glogin.sql) sets the prompt of sqlplus to the instance I am connecting to:

select lower(substr(global_name,1,(instr(global_name,'.')-1))) sid from global_name;
set sqlprompt 'SQL &osid>'

It works fine, but when I do a 'connect' again, it will not reflect the new instance.

Is there a way around this? I want the prompt to show the correct instance that I am connected to.

Thanks.

Regards,
Tse Chong Received on Sat Apr 25 1998 - 01:42:23 CDT