Shulou(Shulou.com)06/01 Report--

This article mainly introduces the method of navicat to view the version of oracle database, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Navicat is a fast, reliable and inexpensive database management tool, so let's take a look at how navicat views the oracle database version.

To view the database version using navicat, you only need to use SQL statements. Different databases need to be queried with different statements.

MySQL

Select version ()

Oracle

Select * from v$instance

Sql sever

SELECT @ @ VERSION

Recommended tutorial: navicat usage tutorial

The following is a detailed picture and text tutorial

1. Open navicat. Enter the main interface.

2. Choose a database at random.

3. Click query, and then select New query

4. Enter the view version of the sql statement, where the mysql used by the editor uses MySQL to demonstrate

Thank you for reading this article carefully. I hope it is helpful for everyone to share navicat's method of viewing the oracle database version. At the same time, I also hope that you can support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.