Oracle Learning 26th Day Toad Trial Experience

Last night want to follow Oracle statement, online someone recommended toad, download to try, probably write down the experience it:

First, the overall feeling

1, Icon +1s, and after the start of "gung", in the mysterious power from the east, unknowingly and continued a second, exciting

2, the interface style is still relatively early style, although there are some parameters can be adjusted in the options (the default is already enhance), but the tune to adjust or some XP, office, and so on, too simple

3, the menu is very rich, the options are also many, I prefer all things can be customized tools.

Second, version

1, the latest version 12.10, 64-bit, only English version

2, the Chinese version has 12.8, 32 bit, did not find any difference

3, green version, and have ready-made SN

Third, the interface

1, the interface can be adjusted to the simplest style, that is, the above menu is not, the following to stay inquiry form. But the bottom assorted's status bar takes up several lines, some uncomfortable

It's toad, and here's plsql.

2, Plsql can be like VS, MSSQL, set up a solution manager on the side, a variety of tables, stored procedures, sequences and so more convenient

Toad to open a dedicated mode browser, much more powerful, but not very convenient

3, Toad settings cannot be exported, Plsql new version can import and export

Four, shortcut keys

1, plsql the latest version can set the shortcut key CTRL + R hide the form below, but can only hide, and then press out, can only re-query. Toad can be set CTRL + R hidden/displayed

2, Toad shortcut key Incredibly can not cancel, can only set a use of shortcut keys. And the conflict is just a sign *, not automatically with the latest settings

3, the most pit dad came, Plsql and SSMs can be set CTRL + E query, checked on the selected, not selected on the execution of all, but toad not ... If only one row is executed, the statement is executed, or it can be set to CTRL + E, if multiple lines are selected, the execution statement with this CTRL + E will be an error. To use "Script execution" (I am set to F5), the results shown are not in the data grid, in another grid 1, Grid 2.

Too inconvenient, every time you have to think about whether the execution of more than the line, because of this shortcoming, may still choose to use plsql for daily development

Five, inquiry

1. Editing

Plsql There are two forms, take rowid out, or add for UPDATE, then the data list there is a lock, click to edit

Toad can only be used with ROWID and cannot be edited using for update. And there is no visual lock when using ROWID.

2. Query Result bar number

Toad to right-click Count rows

Plsql there seems to be no good way

Vi. Other

1, Plsql can not set the landing shortcut key, February 18 recorded the bug, then the version seems to be 1814, today upgrade to 1818, found not resolved ...

2, Plsql Everyone with more, the server is also mostly loaded is this, although Toad has green version, but also can not be used temporarily to copy a server it

3, TOAD64 bit the latest version, as if there is a SQL optimization analysis of the cry, 32-bit start-up prompt did not install the optimizer component, did not try the optimizer, may later encounter complex script will be taken to try.

4, Toad "database" and "monitoring" relatively easy to use, some like the profiler of SSMs, but yesterday research out using statement tracking, this demand is not so urgent

Conclusion: If it wasn't for the big pit Dad's query to differentiate multiple lines, I might use Toad to try it for a while, after all, with older people's blessing, various functions and configurations look very powerful. But now we can still use Plsql.

Oracle Learning 26th Day Toad Trial Experience