Introduction to Oracle common Third party software

Oracle
Abstract: Ancient saying: "工欲善其事, must first get its device", although it feels that those who use the command line, script to play Oralce is a warrior, but with good third-party software can make our use of Oracle level to play to the extreme, and thus greatly improve our application of Oracle efficiency.

First, it is worth a problem is Pl/sql Developer, which is almost Oracle's heroes are in the use of software, but also my favorite software, strongly recommended:

1. Software Evaluation: ★★★★★

2. Advantages:

A, full and support oracle7.x, 8.x, 9i, the use of OCI direct Oracle, efficiency is the best of the same software, no less than sqlplus slow.

b, it is a multi-threaded application, unlike Toad or Sqlplus executed a large operating interface is like dead.

C, it also introduced the concept of project, very suitable for application development, debugging stored procedures, some of the basic structure of Oracle in it also has a corresponding template, very convenient.

D, it built a similar sqlplus command line interface, but can be much better than sqlplus, try you know.

E, it's also perfect for you to manage and tune, kill processes, unlock, generate library-like reports, compile invalid Oracle objects, view statement execution plans, and more.

F, it also has a similar Delphi, VB Statement of the function of the automatic prompt

3. Disadvantages:

It does not like Toad to display some of the functions commonly used by DBAs graphically, such as the use of table space than these content, the program should be further enriched.

4, other content

The most version of Pl/sql developer is 5.1.2.687 about Pl/sql developer A more detailed description can refer to

Http://www.allroundautomations.com/plsqldev.html

It can also be downloaded to a fully functional version of the Pl/sql developer for 30 days.



Second, say a toad, maybe when I say pl/sql developer, someone is going to argue with me, this is also a great Oracle Third-party software, whether it is development, management, tuning you can use, is also a very high rate of a software.

1. Software Evaluation: ★★★★★

2. Advantages:

A, development function is very prominent, fully support Oracle's various objects, such as tracking debugging stored procedure features are available, and very useful.

b, the management is also very perfect, such as database Monitor,tablespace map and so on tools are particularly rich, and the appearance of a better performance.

c, use it to tune also very much.

3. Disadvantages:

A, it is a single-threaded program

b, it has too many functions, it takes some time to study it carefully.

4, other content

The latest version of Toad is 7.5.2, in

Www.quest.com can download to, need to register a user, but is free, patience is good.



Three, the commonly used multidimensional object BROWSER, this software also has many people to use, the function is also good, I met many people all uses it to debug the stored procedure.

1. Software Evaluation: ★★★★

2. Advantages:

A, for those who do not like E-Wen's friend, this software is a gospel, because it is a Chinese interface, the appearance is also very beautiful.

b, fully support the development of Oracle8i database, management platform. Support new Java objects in Oracle8i, provide tracking debugging of database stored procedures, SQL efficiency analysis, database performance adjustment, document generation, dynamic monitoring and many other functions, 9i supported version is under development.

C, you can save the results of the select directly into Excel format.

D, it is very cheap and, a user's only 1000 yuan.

3. Disadvantages

A, because it is developed with Delphi, the program is using BDE and Oracle connection, so the execution of SQL statements is inefficient.

B, is also a single threaded application, many features have yet to be improved.

4. Other

Its latest version is 7.0.12.52.

In http://downxp.net/soft/4944.htm can down to



Four, Embarcadero Rapidsql, a full-featured software, for Oracle, Sybase, DB2, SQL Server support is good:

1. Software Evaluation: ★★★★

2. Advantages:

A, has the popular Oracle third party software's function, the efficiency is also very good, by some places evaluates as a five-star software.

B, Embarcadero Company is good, it fully supports the ORACLE,SYBASE,DB2 and SQL Server, for those who use or are struggling to find a useful Sybase Third-party software is a boon.

3. Disadvantages:

The look of the query results doesn't feel comfortable.

4. Other

Its latest version is 7.0.1.

In http://www.51delphi.com can down to





Benthic Company's Oracle software, which includes Golden, Pledit and IMPEXP32 software.

1. Software Evaluation: ★★★

2. Software Introduction

This software is a bit more professional software, each to do their own things, have done some Oracle's designated functions.

A, golden is mainly used for query, you can open multiple windows, the use of very aspects. It seems to be multithreaded, but is actually single-threaded.

B, Pledit is mainly used to manage storage objects, such as creating, compiling, debugging stored procedures, batch of invalid storage objects to compile and so on. When you want to manage the stored procedures, backup and other operations must think of it, it is every oracle with a prerequisite for the software.

C, IMPEXP32 is installed with the golden, do not install separately, it is used to import TXT files into Oracle, very useful. After using it I was not going to use the sql*loader.

3, other content

These software can be downloaded to the www.benthicsoftware.com.



Knot article:

These software is part of my more commonly used third party software of Oracle, and I like the part, Oracle's third party software is too much, others also commonly used PB, SQL Navigator and other tools to deal with Oracle, I certainly include some of my own preferences here, but I still hope to benefit from your work.