login.sql to set sqlprompt
From: Lee Parsons <lparsons_at_eskimo.com>
Date: Mon, 20 Mar 1995 22:37:34 GMT
Message-ID: <D5rG6s.AHy_at_eskimo.com>
Date: Mon, 20 Mar 1995 22:37:34 GMT
Message-ID: <D5rG6s.AHy_at_eskimo.com>
The following is a login.sql I'm hacking together to set sqlprompt. I've having trouble getting it to look quite right. before I spend too much time on it. anybody got a login.sql they want to share.
set termout off
set pagesize 0
spool foo.sql
select 'set sqlprompt '''||rtrim(instance)||user||'>''' from v$thread;
spool off
_at_foo.sql
set pagesize 14
set termout on
-- Regards, Lee E. Parsons Systems Oracle DBA lparsons_at_world.std.comReceived on Mon Mar 20 1995 - 23:37:34 CET