Database tools toad and PLSQL

These two are the most commonly used database tools. They cannot be good or bad. Each has its own merits. From the perspective of the number of users, we can see that they have their own reasons. I know each other:

When PLSQL is used at the beginning, it prompts automatically andEditIt is very convenient, with special emphasis on compilation. PLSQL is very easy to write, and there is an automatic test connection auto. I used to like it very much. If it does not take a long time, the connection will be disconnected, when toad is used for a short time, the system prompts that the database connection has been disconnected for a long time without any response. In addition, Oracle clients must be installed for PLSQL connection.

The Toad tool is very powerful. It integrates various functions and is very shocking to him. All kinds of management functions can satisfy you. PLSQL manages a lot of databases. In addition, the toad connection methods are diverse. You do not need to install the Oracle client [It can connect to Oracle]. In addition, many people have toad's data table names and fields, and the automatic prompt function is very weak. I just thought so, I just didn't know him. At that time, I found that the use of palettle could help me remember to show that the toad prompt function was stronger. In fact, I wrote some instructions and then used CTL +. you will find it very powerful and feel like you want to develop powerful editing functions of IDE eclipse, vc6 vs2005, and other editing tools. Greatly improve work efficiency (if you are too powerful, you will still need to remember frequently used table names and field functions, APIs, etc., and try to remember other table name and field function APIs, etc, you can use the power after you are strong. Otherwise, you will be unable to cope with the harsh environment)

Note: PL/sql8.0.2.1505 toad 9.7.0.51