Re: SQL*Plus question (Where am I)

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.