Toad for Oracle 9.7

Toad for Oracle 9.7 is a database tool offering a wide range of features for building and maintaining database programs including PL/SQL and SQL scripts, which has a PL/SQL and SQL debugging suite and built-in knowledge bases: Knowledge Xpert for PL/SQL and Knowledge Xpert for Oracle Administration. The Toad for Oracle install also includes Toad for Data Analysts for multi-platform querying and reporting. You can:

• Visually create queries and execute them
• Construct and manage database objects
• Share project assets such as templates, scripts, and code snippets, with other team members using Project Manager
• Record workflow steps and play them back later with AppDesigner
• Profile your PL/SQL code to find performance bottlenecks and check for code coverage
• Access data (from any data source), understand data relationships and quickly produce reports with Toad for Data Analysts
  

Toad for Oracle also has its own team collaboration utility called Team Coding. Team Coding works with Toad's editor to control code access.

Are you an Oracle database professional responsible for any of the following tasks?

• Oracle database development
• Writing Oracle SQL queries (and queries on other database platforms - enabled through Toad for Data Analysts) and generating reports
• Formatting code, ensuring coding standards are met
• Working with PL/SQL
• Debugging
• SQL tuning
• Maintaining overall database performance
• Troubleshooting
• General database administration and maintenance
• Managing database or application changes
  

Today’s economic environment leaves no room for error. Any misstep could damage your business and your reputation. Additionally, the volume of data in your environment is not letting up and you are often forced to do more in less time with less help. Quest Software’s Toad for Oracle can rescue you from this predicament. It gives you the power to not only build great code and prevent costly coding errors, but also simplifies the management and maintenance your Oracle databases. And, with the built-in component Toad for Data Analysts, you can also access non-Oracle databases for querying and reporting.

Major Features:

1. Toad® for Oracle provides:
   • Greater efficiency when performing daily tasks
   • Greater accuracy when writing, debugging and tuning code
   • Flexibility to perform many development and administration tasks from a single tool
   • A smooth workflow that allows users to move from one task to another easily
   • Extensive reporting capabilities that produce quantifiable data and documentation
   • Access to Oracle expertise through various Toad user communities, including Toad World
2. Essential Functionality
   • Object browsing and navigation
   • Editing capabilities: snippets, intellisense, synta highlight, code folding
   • Customizable code templates and code formatter
3. Development Functionality
   • Query Builder
   • Integrated Debugger
   • ER Diagram
   • Build database code dependencies diagram (Code Roadmap)
   • Compare code difference in database objects and files
   • Eternal/remote debugging (used when the db code is called from apps. like Java, C++, VB, etc.)
   • Convert embedded SQL to other programming environments languages (Delphi, C, C++, Java, Perl and VB etc.)
4. Team Collaboration
   • Sharing common standards and templates
   • Integrates with more than 10 version control systems
   • Manage projects

Enhancements:

• Getting-started Videos – Useful video clips show the “Top Things You Should Know” for developers and DBAs – videos reduce the Toad learning curve and allow you to take advantage of the most useful features
• Action Recall Enhancements – Save the steps you take in Toad – like a macro – and replay or schedule to run whenever you want, or even distribute to others; new AppDesigner window makes it much easier to create an automation workflow based on multiple saved actions to generate an entire process
• Subversion VCS Support – Complete support for the Subversion version control system
• Parser Enhancements – Toad 9.7 now supports full parsing of Oracle 11g
• Toad for Data Analysts – included for free with all licensed copies of Toad for Oracle