Tuesday, January 22, 2008

How to see the database version?

By Radoslav Rusinov

To view components and their versions, loaded into the database:

SELECT comp_name, status, version FROM dba_registry;

To view version numbers of core library components, including the database:

SELECT banner FROM v$version;

To display options that are installed (the value column is ‘FALSE’ if the option is not installed)

SELECT parameter, value FROM v$option;

1 comment:

Libby said...

Nice post. You have shared a lot of helpful commands in your blog. Many of them I have not learnt and tried earlier. It will an interesting option to try all of them and to learn each of them that will increase my knowledge too. Thank you.
sap upgrades

Some/All/Major of the blog content is not mine and i'm not the writer of it, all rights reserved to the authors.