Re: login.sql to set sqlprompt
From: Tom Robbins <trobbins_at_paul.spu.edu>
Date: Thu, 23 Mar 1995 16:14:04 -0800
Message-ID: <Pine.OSF.3.91.950323161204.9685B-100000_at_paul.spu.edu>
Tom Robbins, Seattle Pacific University trobbins_at_paul.spu.edu http://paul.spu.edu/~trobbins Received on Fri Mar 24 1995 - 01:14:04 CET
Date: Thu, 23 Mar 1995 16:14:04 -0800
Message-ID: <Pine.OSF.3.91.950323161204.9685B-100000_at_paul.spu.edu>
On Mon, 20 Mar 1995, Lee Parsons wrote:
> too much time on it. anybody got a login.sql they want to share.
>
How about:
column name new_value name_v
select name from v$database;
set sqlprompt &&name_v>
It may be quicker than opening and closing output, depending on your operating system.
Tom
Tom Robbins, Seattle Pacific University trobbins_at_paul.spu.edu http://paul.spu.edu/~trobbins Received on Fri Mar 24 1995 - 01:14:04 CET