This is the mandatory tool for oracle developers and DBA, its very use full for developing functions, procedures, packages, triggers and much more. Further more its also used for query optimization.

* The focus is on programmer/analyst productivity, rather than DBA-level needs (e.g. account maintenance, etc). * By this I mean they've developed a powerful database browser that integrates with their solid, extensible code editor. So it's easy to search, review, edit and check-in your database and code objects. * I love the ability to choose the function keys for every bit of functionality in the product, so I can be most productive. * The Code Beautifier allows you to develop and enforce code style standards, and it can guide you to use standard naming conventions. * When writing SQL or PL/SQL, you can select a keyword and hit a single key to seach Oracle reference documents for assistance. * The Code Assistant provides help with the call syntax to standard Oracle or your custom routines. * Editable code templates let you easily drop standard coding methods right into your program. * The code testing window, with included debugger, is very powerful, yet very usable for quickly running a code fragment. It also includes a Test Manager, which lets you develop suites of test scripts for large-scale regression testing. * PL/SQL Developer also supports extending the product via creating plug-ins, to enhance the editor and other product functionality. * Direct integration with code repository tools - Git and SVN. * The product continues to add new productivity improvements with each major version, though they aren't always features I use.

Executes Continuously the SQL statement you want to use