Re: How do I determine the server version and name in SQL?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 24 Jan 2000 19:31:11 +0800
Message-ID: <388C37FF.387F@yahoo.com>

Malcolm Dew-Jones wrote:
>
> Hello...
>
> Does anyone know how to find the version of the database server software
> besides from the original connect message when using SQL/Plus?
>
> Does anyone know how to find the name of the database server when using
> SQL/Plus?
>
> I am working on project where it's most convenient to be logged-in to
> several different servers at the same time, and it would be very
> convenient to be able to double check which system I was logged-into
> before doing some operations.
>
> thanks, malcolm

v$version
v$instance
global_name

should help

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Jan 24 2000 - 05:31:11 CST