How to Check Oracle Database Version

by

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.
How to Check Oracle Database Version in SQL Developer
How to Check Oracle Database Version in SQL Developer
  • You can also use the query to check the version of oracle database running in SQL deverloper tool. 
SELECT * FROM v$version;
How to Check Oracle Database Version in SQL Developer using Query
Check Oracle Database Version in SQL Developer using Query

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;
How to Check Oracle Database Version in Windows
Check oracle database version in windows

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