Re: SQL*Plus question (Where am I)

Trick is $500 per license, made payable to billgates_at_microsoftsucks.com.

In article <8rlip4$vsa$1_at_nnrp1.deja.com>,   STiger2000 <stiger2000_at_my-deja.com> wrote:
> 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.
>

--
Christopher R. Spence
OCP, MCP, MCSE, A+, RAPTOR, CNA


Sent via Deja.com http://www.deja.com/
Before you buy.