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 question, it is 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, and is not slow than 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 prompts similar to Delphi, VB statements. rich. 4. Other contents 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 function 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, the advantages: A. The development function is very highlighted, fully supporting the various objects of Oracle, such as tracking the storing storage 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, Disadvantages: A. It is a single-threaded program B. Its function is too much, and it takes a study of more than some time. 4, the latest version of Toad toad is 7.5.2, you can download it at www.quest.com, you need to register a user, but it is free, patience 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, the advantages: a, for those who don't like E text, this software is a gospel because it is a Chinese interface, 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.
