TOAD

What is Toad for Oracle?

Toad is an industry-standard tool for application development. Using Toad, developers can build, test, and debug PL/SQL packages, procedures, triggers, and functions. TOAD users can create and edit database objects such as tables, views, indexes, constraints, and users. TOAD.s SQL Editor provides an easy and efficient way to write and test scripts and queries, and its powerful data grids provide an easy way to view and edit Oracle data. Use Toad to

*
Create, browse, or alter objects (tables, views, indexes, etc.) including Oracle8 TYPE objects
*
Graphically build, execute, and tune queries
*
Edit and Debug PL/SQL and profile "stored procedures" including functions, packages, and triggers
*
Search for objects
*
Find and fix database problems with constraints, triggers, extents, indexes, and grants Toad utilizes direct Oracle OCI calls for full access to the Oracle API.

http://asktoad.com/DWiki/doku.php/faq/answers/getting_started?DokuWiki=4753bcaa735abe33060cd751e786ba16#what_is_toad_for_oracle