Exemplary Tips About How To Check Database Version In Oracle
In sql developer, click the reports tab on the left, near the connections navigator.
How to check database version in oracle. Start the oracle enterprise manager and logon to the database. Find oracle database version using v$instance. There are many ways to check database version.
Don't have a my oracle support account? To determine the version of oracle database components do the following: Query to check oracle version.
In sql developer, click the reports tab on the left, near the connections navigator. Here are seven ways to check which version of oracle database you’re running. I am not sure what exactly you mean by what type of database am using but you can try this:
Select version from product_component_version where product like 'oracle database%'; Under instance > configuration the. To view full details, sign in with your my oracle support account.
This will give you detailed version. Oracle 9i on aix server: If user have dba privilege then user can access database version information in v$instance view.
You can use anyone method to get the result. To get current database version, we can query v$version for sure. Connect to sql*plus it will show you the.