Toad for Oracle

Manage all your databases easily whether on-premise or in the cloud. Control access to protect databases against attack. Browse and navigate database objects like tablespaces, rollback segments and roles. Execute one or more scripts against one or more databases. Automate routine admin tasks.

Use Jump Search to quickly find information on topics, inside and outside of Toad. Extensive help is available, including access to user community forums on Toad World directly from Toad for Oracle.

Take advantage of code analysis to ensure code standards are followed and help reduce unplanned development cycles. (Available with some editions.)

Perform PL/SQL unit testing with Code Tester to ensure correct function, and use Benchmark Factory for scalability testing for defect-free applications that scale in production. (Available with some editions.)

View and edit data. Import and export data from/to multiple sources. Subset and mask data from production. Generate relational data for testing. Report on data and output to multiple file types.

Get recommendations for performance, connection, or other issues based on your environment.

Dramatically improve the execution time of SQL and PL/SQL code with SQL Optimizer and help applications run faster in production (Available with some editions.)

Get additional health checks and other administration capabilities through the Database Admin module. Use Spotlight’s diagnostic aids to help determine root cause of performance issues. (Available with some editions.)