How to check the oracle database version in navicat

Navicat is a set of fast, reliable and quite cheap database management tools. Below we will introduce to you how to check the Oracle database version with Navicat.

Use navicat to check the database version, just use SQL statements. Different databases require different statements to query.

MySQL

select version()

oracle

select * from v$instance

sql sever

SELECT @@VERSION

Recommended tutorial: navicat usage tutorial

##The following is a detailed graphic tutorial

1. Open navicat. Enter the main interface.

#2. Select a database at will.

3. Click Query and select New Query

4. Enter the sql statement to view the version, here The editor uses mysql, so I use MySQL for demonstration

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