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!