In this Oracle tutorial, we will learn how to check oracle database version. Also, we will cover these topics.
- How to check Oracle Database Version in Linux
- How to check Oracle Database Version in SQL Developer
- How to check Oracle Database Version in Toad
- How to check Oracle Database Version in Windows
- How to check Oracle Database Version in Solaris
How to Check Oracle Database Version in Linux
In this section, we will learn how to check the oracle database version in Linux using the command line or Terminal.
Using the below command on a terminal of the Linux operating system we can display the current version of the current oracle database.
cat /etc/oracle-release
Read Oracle 19c installation on Windows 10
How to Check Oracle Database Version in SQL Developer
In this section, we will learn how to check the oracle database version in the SQL Developer tool.
- SQL Database tool is an IDE (Integreted Development Environment) that facilitiates oracle developers to write queries with Graphical User Interface (GUI).
- To check version of oracle database running on SQL developer tool ‘Navigate to Reports‘ expand ‘Data Dictionary Reports‘ inside data dictionary report expand ‘About Your Database‘ and from there click on ‘Version Banner‘.
- The moment you will click ‘Version Banner’ there will be a prompt with the version of oracle database running on the SQL developer tool.

- You can also use the query to check the version of oracle database running in SQL deverloper tool.
SELECT * FROM v$version;

As you can see oracle database 19c is installed on this SQL developer tool.
Read How to Get List all Tables in Oracle Database
How to Check Oracle Database Version in Toad
In this section, we will learn how to check the oracle database version in the toad.
- Toad is an advance database software that is used for commercial purpose mainly.
- To check the version of oracle database in toad software write the below query.
SELECT * FROM v$version;
Read: Oracle Add Foreign Key
How to Check Oracle Database Version in Windows
In this section, we will learn how to check the oracle database version in Windows operating system using command prompt (cmd).
Below is the command line to check oracle database version in windows 10 operating system.
select * from v$version;

Read Connect Excel to Oracle Database
How to Check Oracle Database Version in Solaris
In this section, we will learn how to check the oracle database version in Solaris. Using the below command we can display the current version of the Oracle database running on the Solaris operating system
cat /etc/release
Also, check: How to Fetch Data from Oracle Database in Python and Number Datatype in Oracle Database.
You may also like to read the following tutorials on oracle.
In this tutorial, we have learned how to check Oracle database version. Also, we have covered these topics.
- How to check Oracle Database Version in Linux
- How to check Oracle Database Version in SQL Developer
- How to check Oracle Database Version in Toad
- How to check Oracle Database Version in Windows
- How to check Oracle Database Version in Solaris
I am Bijay having more than 15 years of experience in the Software Industry. During this time, I have worked on MariaDB and used it in a lot of projects. Most of our readers are from the United States, Canada, United Kingdom, Australia, New Zealand, etc.
Want to learn MariaDB? Check out all the articles and tutorials that I wrote on MariaDB. Also, I am a Microsoft MVP.