How to check the version of oracle?

View method: 1. Open xshell and log in to the server, first switch to the oracle user; enter "sqlplus / as sysdba" on the command line to view; 2. Log in to oracle in plsql, create a new sql window and enter "select * from v$version" command.

How to check the oracle version?

Method 1:

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

Then enter on the command line sqlplus / as sysdba

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.

Method 2:

Open plsql, the login interface will pop up, enter the oracle username and password, 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. The result is as shown in the figure below Show

Recommended tutorial: "Oracle Tutorial"

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