Heroes Collection: Oracle Common Third Party Software Introduction
Abstract: The ancient words: "Wrathone do it, you must first get the device", although it feels that the use of the command line, the script is playing Oralce is heroes, but with a good third-party software can put We use Oracle levels to the extreme, and thus improve our efficiency of our application Oracle.
First, the first thing is worth a problem, the PL / SQL Developer, which is almost Oracle's heroes are using software, and it is my favorite software, strong recommendation:
1, software assessment: ★★★★★
2, advantages:
A, full support Oracle7.x, 8.x, 9i, using OCI direct Oracle, efficiency is the best in the same software, determined to slow down by SQLPLUS.
B. It is a multi-threaded application, unlike a large operation interface like TOAD or SQLPLUS is like death.
c, it also introduces the concept of Project, very applicable to the development, debug stored procedure, some Oracle's basic structure has the corresponding template in it, which is very convenient.
D, it built into a command line interface similar to SQLPlus, but it is much better than SQLPlus, try it.
E, it is also ideal for your management and tuning, killing processes, unlocking, generating a report of the library, compiling an ineffective Oracle object, and seeing the statement's execution plan, etc. These features are available.
f, it also has the function of automatic prompt similar to Delphi, VB statement
3, shortcomings:
It does not appear like TOAD to show some of the DBA common functions in graphics, such as the use of tablespaces than these content, procedures should be further enriched.
4, other content
The most detailed introduction of PL / SQL Developer is 5.1.2 .687 About PL / SQL Developer more detailed introduction to http://www.allroundAutomations.com/plsqldev.html, and can also download to 30 days full-featured PL / SQL Developer version.
Second, talk about toad, maybe when I say that PL / SQL Developer, someone wants to debate my debate, this is also a special Oracle's third party software, whether it is development, management, tuning you. It can be used, and it is also a software that is very high.
1, software assessment: ★★★★★
2, advantages:
A. The development function is very prominent, fully supporting the various objects of Oracle, such as the tracking of the storing process function, and it is very easy to use.
b, management is also very perfect, such as Database Monitor, TableSpace Map, etc. Tools are particularly rich, and is expressed in a better appearance.
c, use it to tune and very convenient.
3, shortcomings:
A. It is a single-threaded program
B. Its function is too much, and it takes a detailed study of some time.
4, other content
The latest version of Toad is 7.5.2, you can download it in www.quest.com, you need to register a user, but it is free, patient is good.
Third, often using multi-dimensional Object Browser, this software has many people in use, the function is also good, I have encountered many people to use it to debug store procedures.
1, software assessment: ★★★★
2, advantages:
A. For friends who don't like E text, this software is a gospel because it is a Chinese interface, and the appearance is also very beautiful.
b, fully support the development and management platform of Oracle8i database. Supporting the new Java objects in Oracle8i, providing tracking debugging debugging, SQL efficiency analysis, database performance adjustment, document generation, dynamic monitoring, etc., the version supported by 9i is being developed. c, you can directly store the result of the SELECT into the Excel format.
D, its price is very convenient, one user's only 1000 yuan.
3, shortcomings
A, because it is developed with Delphi, the program is used by the BDE and Oracle, so the execution efficiency of the SQL statement is very poor.
B, is also a single-threaded application, and many features remain to be improved.
4, other
Its latest version is 7.0.12.52, at http://downxp.net/soft/4944.htm can Down to
Fourth, Embarcadero Rapidsql, a full-featured software, support for Oracle, Sybase, DB2, SQLServer:
1, software assessment: ★★★★
2, advantages:
A. The function of the popular Oracle third-party software is very good, and it is ranked as a five-star software in some places.
B, Embarcadero's production, it is good, it fully supports Oracle, Sybase, DB2, and SQL Server, friends who use or suffer from these things that can't find a good Sybase third-party software, but a gospel.
3, shortcomings:
The appearance of the results of the query is uncomfortable.
4, other
Its latest version is 7.0.1, at http://www.51delphi.com you can DOWN
V. Bench's Oracle software, including Golden, PLEDIT, and IMPEXP32.
1, software assessment: ★★★
2, software introduction
This software is a professional software, each doing things, complete some specified features of Oracle.
A. Golden is mainly used for queries, you can open multiple windows, which is used very much. It seems that it seems to be multi-thread, which can actually be single thread.
B, PLEDIT is mainly used to manage storage objects, such as creation, compiling, debug stored procedures, compiler for invalid storage objects, etc. When you want to manage the stored procedure, you must think of it when you are operational, it is a software that must be performed with Oracle.
C, IMPEXP32 is installed with Golden without separate installation, which is used to import TXT files into Oracle, which is very easy to use. After using it, I don't have to use SQL * Loader.
3, other content
These software can be downloaded at www.boundhicsoftware.com.
Complete:
These software is part of the third-party software I have more commonly used, and I like some part. Oracle's third-party software is too much. Other everyone often uses PB, SQL Navigator and other tools to deal with Oracle, I It is of course some of the preferences to you, but I hope to bring your work to your work.
