BI Decision

Sunday, October 15, 2006

TOAD

No one who writes a lot of SQL should be using the clients that come with databases. SQL*Plus and the DB2 Command window work, but they lack the tools of a modern development environment.

My favorite is TOAD. Despite the acronym (Tool for Oracle Application Developers) TOAD comes in flavors for DB2 and SQL Server as well. The freeware versions for DB2 and SQL Server are a relatively new development.

Try the free version (which can be a bit hard to find on the website)
Other good tools are PL/SQL developer, WinSQL, Rapid SQL, and the new Oracle SQL Developer.