Qingyun oracle tools

Oracle’s common third-party tools are mainly: toad, PLSQL Developer, and object browser; each has its own advantages and disadvantages: toad is mainly powerful; PLSQL Developer is mainly accurate in compilation; object browser is mainly user-friendly; but in the usual program development process , even if you use the above tools, it still doesn’t feel particularly convenient.

For this, I made a simple oracle tool:

1. It can conveniently generate various common SQL statements for selected fields. It is a powerful tool for developers to debug and generate SQL.

2. Right-click on each list to sort, filter, search, print, and export to multiple formats, including Access.

3. It is very convenient to view the table structure, and it is also very convenient to maintain and debug the data of the table.

4. It is very convenient to modify the TABLE name, VIEW name, and COLUMN information. The most important thing is that it is very convenient to modify their comments (some well-known software does not even provide the processing of View field comments).

5. All field information can be listed for easy comparison. General tools only provide the relationship between tables and fields, and cannot list query processing for fields.

6. In general databases, the same field name may be used in multiple tables. In most cases, its type, length, and remarks are basically the same. However, we are often careless when designing and set different type length comments for the same field name, so I made a "same name field check" function that can check these problems and make batch changes. This is also the biggest highlight of the software.

7. Oracle has a characteristic that if the table structure changes, many views, stored procedures, triggers, etc. will become invalid. At this time, these invalid objects must be recompiled. But this action is often forgotten, so I added a function to retrieve and correct invalid objects.

8. You can monitor the shared area to understand the bad SQL and execution plans.

9. You can connect to the database on "bare metal", which means you don't need to install the Oracle client.

10. Compatible with 5 versions of oracle8,9,10,11,12.