quoted from Baidu Encyclopedia:Navicat for Oracle is a powerful set of Oracle database system management tools. It has a clever graphical user interface (GUI) that allows you to create, organize, access and share information quickly and easily in a secure and easy way. Navicat for Oracle enables users to connect to local/remote Oracle Server, providing useful tools such as data/fabric synchronization, import/export, backup, and reporting to assist in the process of managing data.
In this paper, the basic usage of NAVICAT for Oracle is introduced by means of graphic method, because the recent project of the Java EE involves remote database connection, so the tool is used. The article is very simple foundation, but still hope to be helpful to you, if there are errors or shortcomings in the article, please Haihan ~
I. Connecting to a remote database
After installing Navicat for Oracle software, run as shown:
Click the "Connect" button to fill in the relevant information such as IP address, and then connect to the remote database as shown in.
after the successful connection, the database looks like this:
PS: For project reasons, this article is about connecting to a remote database, but the same is true for local operations.
two. Create a database table
Create a new database table by clicking New Table on the taskbar, or by right-clicking in an empty space.
New Table T_user_info, where "add field" inserts the appropriate fields into the table, the fields I currently insert include: ID (ordinal), USERNAME (username), PWD (password), STATUS (permission), Dw_name (unit name), Dw_ Code (Unit code), you can set the primary key, non-empty properties, add comments and other operations.
At the same time, the taskbar also has indexes, foreign keys, triggers, permissions for us to set. This article mainly introduces some basic knowledge, will be used basically, there is a chance to give you a deeper explanation of these usages.
also, if you want to modify the information for a table that you have already created, you can do so by using the method shown. Right-click the table t_user_info "Design Table" to modify the table structure on the row.
You can view the user information by tapping "open Table", as shown in, as well as delete the table, clear the table data, copy the table, and so on.
three. Database deletion and modification
Here I will combine SQL statements and navicat for Oracle software to explain the database additions and deletions. When you click "Query =" to create a new query, the SQL-supported commands include the following:
Data Definition language (DDL): Create, Alter, drop
Data manipulation Language (DML): Insert, delete, UPDATE, select
Data Control Language (DCL): Grant, REVOKE
Transaction Control Language (TCL): Commit, savepoint, rollback
1. Insert operation
Insert into T_user_info (Id,username,pwd,status,dw_name,dw_code) VALUES (' 1 ', ' eastmount ', ' 123123 ', ' 2 ', ' Dean's Office ', ' 10001 ') );
The results are as shown, and you can set the results to appear in ascending order.
ps:oracle Setting the ordinal ID increment method is more troublesome than checking auto_increment like MySQL.
2. Update Operations
Update t_user_info set username= ' Yang Xiuyu ' and pwd= ' 123456 ' and status= ' 2 ' and dw_name= ' software Academy ' and Dw_code= ' 08111003 ' where id= ' 0 ';
but error: [ERR] ora-00933:sql command not properly ended
Orcale syntax differs from MySQL in that you need to use commas instead of and.
Update t_user_info set username= ' Yang Xiuyu ', pwd= ' 123456 ', status= ' 2 ', dw_name= ' Software Academy ', dw_code= ' 08111003 ' where id= ' 0 ';
the results of the operation are as follows:
3. Query operations
SELECT * from T_user_info where username= ' Yang Xiuyu ';
the query results are as follows:
4. Delete Operation
Delete t_user_info where id= ' 0 ';
the results of the operation are as follows:
PS: In the database operation, the real site project will be combined with SQL statements and Java variables, when the space between the suggestions are deleted, otherwise it is easy to update automatically add spaces and other errors. such as:
String sql= "Delete t_user_info where id= '" +id+ "'";
four. Database Import and Export
1. Exporting Data
Select the Excel2007 file as follows:
Click Next to export:
It's a good idea to select "Include column headings" and add headings in Excel:
the output looks like this:
2. Import Data
the steps to import data are as follows:
five. Automatic database backup
The database backup, as shown, is saved as a SQL file:
Finally hope that the article is helpful to you, if there are errors or deficiencies in the article, also please Haihan ~ May write some more deep Orcale database related articles, especially how to improve the performance of the database, the actual project.
(By:eastmount late 2016-04-06 1 o'clock http://blog.csdn.net/eastmount/ )
Database Navicat for Oracle Basic usage graphic INTRODUCTION
