How to query the oracle database version

How to query the Oracle database version: 1. Open xshell and log in to the server; 2. Enter "sqlplus / as sysdba" on the command line and hit Enter to print out the version information.

The operating environment of this article: Windows7 system, Dell G3 computer, oracle 11g version 11.2.0.1.0.

How to query the oracle database version?

Check the oracle version:

Method 1:

Open xshell and log in to the server, first switch to the oracle user

Then enter sqlplus / as sysdba on the command line

Press Enter to print out the version information

The output information shows that the oracle version is 11.2.0.1.0, please look at the red box in the image below.

In fact, it was already displayed in the previous step

Let’s take a look at a more professional version

Enter sqlplus -v to type Just press Enter, please see the picture below

Method 2:

Open plsql, the login interface will pop up, enter the oracle username and password, and click ok to log in

After logging in, create a new sql window and enter the following SQL

select * from v$version;

You can choose the execute button to execute, or you can directly Press the F8 shortcut key to execute, and the result is as shown below

Related recommendations:oracle database learning tutorial

The above is the detailed content of How to query the oracle database version. For more information, please follow other related articles on the PHP Chinese website!