Re: Oracle newbiew question

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Mon, 22 Jan 2001 12:04:53 -0000
Message-ID: <980165197.11713.0.nnrp-10.c30bdde2@news.demon.co.uk>

echo $ORACLE_SID from the command prompt - or !echo $ORACLE_SID from sqlplus.

"David S. Cho" <nachosrule351_at_hotmail.com> wrote in message news:3A6ACD1C.7A094727_at_hotmail.com...
> I just got an Oracle accont from my UNIX administrator.
>
> And I just logged onto sqlplus for the first time. Then I preceeded to
> create a table, populated it with some data. So far, so good.
>
> But how in the world do I find the name of the database that the new
> table is in? My guess is my login account is, but is there a command
> that will tell me the name of the current database?
>
> Your help will be much appreciated.
>
Received on Mon Jan 22 2001 - 06:04:53 CST