Home > Database > navicat > How to check the oracle database version in navicat

How to check the oracle database version in navicat

angryTom
Release: 2019-08-10 13:36:24
Original
13725 people have browsed it

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()
Copy after login

oracle

select * from v$instance
Copy after login

sql sever

SELECT @@VERSION
Copy after login

Recommended tutorial: navicat usage tutorial

##The following is a detailed graphic tutorial

1. Open navicat. Enter the main interface.


How to check the oracle database version in navicat

#2. Select a database at will.

How to check the oracle database version in navicat

3. Click Query and select New Query

How to check the oracle database version in navicat

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

How to check the oracle database version in navicat

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template