Re: Default login script - to a DB

If the databases have been named uniquely, a "select * from v$database" query will do the trick. You might need the DBA(s) to grant the view to PUBLIC. John Wunderly.

John Ratzan <Ratzan_at_us.ibm.com> wrote in article <35bdf97c.0_at_news1.ibm.net>...
> I have a login script that is logging me into a DB, but I do not know
which
> DB.
>
> Is there a command in SQL Plus from the command line to return the name
of
> the DB?
Received on Tue Jul 28 1998 - 21:01:38 CDT