Oracle Learning Notes-----Toad User Guide

1.0 Overview

Toad is a very useful Oracle database Graphical management tool, the only drawback is that the Chinese version of the hard to download, for the people just used, very inconvenient. When I just use eclipse, it is the same feeling, so I downloaded the Chinese plug-in package, but 2 weeks later, I took it off, because the big environment is the use of English version, so now sometimes see a colleague of the Chinese version of Eclipse, often can't find some options, instead of getting used to it. In general, Toad is the isqlplus version of Oracle, which is more powerful. Of course, we can also use the C # win form to implement a simple toad-like Oracle graphical management tool! With the toad, like to build a table what kind of can not be implemented by building a table statement, in fact, we click the button at the same time, the underlying trigger is generated by the corresponding SQL statement, and then through the parameterization of the SQL statement, in C # in code to execute the SQL, So it is not difficult to write a simple management tool, it is difficult to do a powerful function, need a deep heat!

fhbds!

1.1 Toad Restore default settings

Right-click on the toolbar---"Select Restore Defaults----" ok!

1.2 Setting the keyword color and font size for SQL statements

Toad default font looks very small, in addition to some keywords such as the name of the table is the default is the earth yellow, look less obvious, you can according to their usual code color custom settings!

Set the font size for SQL statements

Select the Toad options under View

Set keyword font color

　　

I generally like the bold font is large, so not to stare at the computer to see, in addition some keywords such as delete (blue), the table name (green), data (red), the number (purple) .... These key things must be set high brightness, but also to separate the color settings, so that many errors can be avoided! Here are my default code color habits!

1.3 Set font size and color for query results

I use the toad is 9.6 version of the query results between the line color is white, and can not be set, the higher version (I do not have a registration code) does not have this problem, in order to make the data easy to distinguish, while making the display more eye-catching, you can set the query display mode!

First, the view----"toad options, and some of the other things in this interface are the alignment settings.

　　

After setting the effect is obviously much better!

　　

1.4 Set how query records are displayed

Mouse over to the field----"Right-click on Excel. You'll find a triangle on the field. Click on a column of the triangle, you can do some filtering functions, the most useful is to put which is empty, which is not empty filter out.

Select Custom.

　　Several commonly used functions appear, which are useful for filtering records.

For example, filter Stuid is greater than 2.

　Uncheck Excel and the triangles on the fields will disappear!

< never end >

Oracle Learning Notes-----Toad User Guide