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

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. Received on Thu Mar 13 2003 - 11:35:29 CET