Re: Server name and version
From: Ban Spam <ban-spam_at_operamail.com>
Date: Fri, 20 Sep 2002 23:35:36 GMT
Message-ID: <Xns928FA8CCD6299SunnySD_at_68.6.19.6>
Date: Fri, 20 Sep 2002 23:35:36 GMT
Message-ID: <Xns928FA8CCD6299SunnySD_at_68.6.19.6>
"Jul" <Julia.Sats_at_sympatico.ca> wrote in news:BYvi9.5005$Ox4.1384878_at_news20.bellglobal.com:
> Hi,
> I can get name of current user using SELECT USER FROM DUAL.
>
> How can I get SID name from such string : scott/tiger_at_serverSID
> and version of DB?
>
>
>
SELECT * FROM V$VERSION;
SELECT * FROM V$DATABASE;
HTH & MVVY
HAND!
Received on Sat Sep 21 2002 - 01:35:36 CEST