Re: getting global_name at SQL*Plus prompt

From: <mkaushik_at_harvestinc.com>
Date: Fri, 23 Oct 1998 01:44:17 GMT
Message-ID: <70on1h$7v4$1@nnrp1.dejanews.com>

> I'm interested in getting the instance and schema name
> to appear an a SQL*Plus prompt. I've received a number
> of methods to do this,

I have been trying to find out how to get the instance and schema name to appear as SQL*Plus prompt. Would appreciate it if you could post that information.
Thanks,
Malini

In article <362DB96C.855892C1_at_bigfoot.com>, Doug Cowles <dcowles_at_us.ibm.com> wrote:
> I'm interested in getting the instance and schema name
> to appear an a SQL*Plus prompt. I've received a number
> of methods to do this, all which work upon the first login,
> which uses the login.sql script. Problem is...
> if I reconnect from SQL*Plus like
> conn scott/tiger_at_somewhereelse
> the prompt will maintain the old information.
> Does anyone know a way around this?
> Thanks in advance,
>
> Doug Cowles.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 22 1998 - 20:44:17 CDT