Re: SQL*Plus question (Where am I)

From: STiger2000 <stiger2000_at_my-deja.com>
Date: Fri, 06 Oct 2000 22:12:57 GMT
Message-ID: <8rlip4$vsa$1@nnrp1.deja.com>

VampireD - Neat Trick! I'm adding it to my bag-o-tricks. Thanks. jc
http://www.networkessentials.com/certified/ocp

In article <8rksv4$ejm$1_at_nnrp1.deja.com>, VampireD <vampired_at_my-deja.com> wrote:
> I no longer use SQL Plus, but a slick trick:
>
> Update login.sql with this:
>
> define gname = 'not connected'
> column global_name new_value gname
> set termout off
> select lower(user) || '@' ||
> replace(global_name,'.WORLD',null) global_name
> from global_name;
> set termout on
> set sqlprompt 'SQL &&gname> '
>
> In article <8r81k3$suf$1_at_slb6.atl.mindspring.net>,
> "Frank Cornacchiulo" <fjcorn_at_mindspring.com> wrote:
> > At the SQL*Plus prompt, is there a way of finding out what database
I
am
> > logeed into?
> >
> > Thanks,
> > FC
> >
> >
>
> --
> Christopher R. Spence
> OCP, MCP, MCSE, A+, RAPTOR, CNA
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 06 2000 - 17:12:57 CDT