Re: how to query DB for version,product & options info?

dominic.morris_at_eidosnet.co.uk (dom) wrote in message news:<c5c9bfea.0303130235.5fab020e_at_posting.google.com>...
> Hi all,
>
> I'd like to gather as much relevent information about an Oracle DB
> instance as possible through SQL statements, for use in a summary view
> of an Oracle DB in my application. Currently I'm using the following
> SQL statement to gain some basic version information about the DB I'm
> connected to:
>
> select VALUE from nls_database_parameters where parameter =
> 'NLS_RDBMS_VERSION'
>
> I'd like to expand on this, in as much of a version-independent way as
> possible. I'm a bit of an Oracle newbie, so I'm not sure what server
> info would be of interest in such a summary view, so any input is
> appreciated.
>
> Thanks,
> dm.

• select banner from v$version;
• desc v$instance
• desc v$database

Regards
/Rauf Sarwar Received on Thu Mar 13 2003 - 16:06:27 CET