TOAD

from Wikipedia, the free encyclopedia
Toad
Basic data

developer Quest software
Current  version 13.1.1 (Toad for Oracle)
operating system Windows
category IDE , utility
License Proprietary
German speaking No
www.quest.com

Toad is the name of several graphical software tools from Quest Software for the development and administration of various SQL database systems.

The original product was developed for the convenient creation and debugging of SQL scripts and PL / SQL programs for Oracle databases . From that time the acronym (derived T ool for O racle A pplication D eveloper ). Since the development of versions for database systems from other manufacturers, the term "Toad" is no longer explained by Quest Software as an acronym, but as the registered name of a product family. TOAD is now also available for databases such as IBM-DB2 , Microsoft SQL Server and MySQL .

Areas of application

In the course of the last few years the functionality of the product has been expanded so that today there are essentially three areas of application: PL / SQL program development, database administration and data analysis. In addition to the debugging function, a code check (code tester), a knowledge base and various tuning aids are available for PL / SQL program development.

The range of functions also includes a comparison of objects, schemas or databases, a LogMiner interface and the possibility of creating objects, users, tablespaces etc. with an identical structure in the same or another database. TOAD also includes functions for less experienced database users and analysts. In addition to a graphical query builder and the option of exporting results windows to Microsoft Excel, this includes , above all, its own reporting engine , so that it is possible to create company reports with graphics etc. from TOAD.

literature

Web links