I uninstalled PL/SQL Developer and compared it with Toad for Oracle.

I uninstalled PL/SQL Developer and compared it with Toad for Oracle.

Previously, PL/SQL Developer was used to manage Oracle, which was inconvenient to use. It is very difficult to open, and there is always an extra box in the upper left corner of the interface. It cannot be set to hide it by default.

The only thing that makes it worthwhile is to have a beautification tool, but later I found that Toad actually has a format tool, so I unmount PL/SQL.

PL/SQL statements are inconvenient to create a table, including modifying the table structure. An error is reported all the time. Although Toad is not very convenient, it is much more convenient than PL/SQL.

Let's talk about other things:

When I used Mysql and Oracle again, I found that the management tools of Oracle databases are really lagging behind.

1) opening is very slow. There are always various pop-up errors, warning that the connection is lost, and Reconnect is required!

2) You cannot preview all tables.

3) It takes at least a few seconds to query the table structure.

4) In short, it is very difficult to modify the table structure.

By default7 # zbphp.com

If I want to uninstall PL/SQL and reinstall my data after oracle, what is the impact?

Oracle is a database system and uses the pl/SQL language. You need to uninstall pl/SQL developer, which is not related to data in oracle.

Oracle 10g R2 database, when you use pl/SQL developer to DELETE data, after executing DELETE FROM TABLE1, it will remain in the execution status,

When deleting a DELETE operation, you need to obtain a table lock, which is being occupied by others. For example, other processes are inserting or changing data into the table. Therefore, during the DELETE operation, wait for other processes to release the lock and obtain the lock. This time is about to wait, and PL/SQL DEVELOPER is in a stuck state, and the program cannot be used, as if the program had a problem.