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!
