Re: which db

select name from v$database;
 Or
select instance_name from v$instance;

HTH NeilC

marc bautis wrote:
>
> using sqlplus on unix is there a command or a view i can query that
> will tell me which database i am in
>
> thanks,
> marc
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
  Received on Thu Jul 20 2000 - 00:00:00 CDT