Get to Know 9.0

Toad was born as a tool for Oracle application developers. Developers would need to work on their SQL statements for their embedded programs and their PL/SQL for their Oracle stored programs. Toad delivered an editor for each of those needs, a la the SQL Editor and the PL/SQL Editor. Toad even offered a fully functional offline text editor for occasions when a user wanted to work on something while not connected to Oracle.

For the 9.0 Release, Toad now offers users the power of all three editors in a single window, the Toad Editor. New users will no longer have to guess which editor they need to open to work on their projects. Existing users will no longer have to switch between windows to perfect their SQL which is embedded in their PL/SQL objects.

The Toad Editor

The first step to start using the editor is to find the main toolbar button to open the Editor. It's in the same position as it was before, e.g. it's the very first button.

- You will see this in the Editor window, the toolbars, the window bar, etc.

Developers who enjoyed a segregated workspace for their PL/SQL programming will not have to adjust their workflows. Toad has an option to open a new editor tab when a PL/SQL object is loaded.

A Toad Editor tab can operate in the following modes:

SQL Automatically configures the desktop to work with SQL statements

PL/SQL Automatically configures the desktop to work with PL/SQL code objects

Text Can handle SQL, PL/SQL, Java, HTML, Plain Text, etc.

HEX Will read any file in HEX format with raw Hex values and text equivalents

XML Will open any text file containing XML with an XML navigation tree

When creating a new Tab, you can specify the tab type. The type of tab selected determines the type of parsing Toad will apply to the text and which Editor Output Panel tabs will be available. The SQL tab will have the classic SQL Editor output tabs and the PL/SQL tab will have the classic Procedure Editor output tabs.

The default tab type for new tabs can be configured. In the editor, mouse-right-click and choose 'Configure Editor Tab Types." From here you can define which desktops are applied for each tab type and what tab type you want as the default.

The new Toad editor now offers context sensitive execution. If you have an editor tab that contains heterogeneous statements (a mix of SQL, SQL*Plus, and PL/SQL statements) then the editor can identify the statement at your cursor and perform the correct execution action. For instance, place your cursor in a select and press the execute button, you get results in the grid. Place your cursor in a CREATE OR REPLACE PROCEDURE statement and press execute, the object is compiled.

• NOTE: If you have multiple statements in the editor then you must trail them with a valid statement terminator such as a semi-colon in order to use the F9 execute method.
• NOTE: Since the Editor can handle multiple statements per tab, SHIFT+F9 is no longer necessary. Simply use F9 and the Editor will automatically send the current statement to Oracle.
• NOTE: You can also highlight the text that you want executed when you press F9, this will not require a semicolon and can be used to quickly execute a portion of a query, like a Sub-query or CURSOR section.
• NOTE: You can still use SHIFT+F9 to execute statements without delimiters as long as they have a blank line to delimit them from your other statements.
• NOTE: If you want to highlight the query fragment at the cursor, use CTRL+H. This will highlight the text that SHIFT+F9 will act against. You can also use this to send statement fragments to the Tuner or have an Explain Plan generated.

Toad's SQL script execution engine has been greatly enhanced in the following areas:

1. Data Grids
2. Running History
3. Layout and Presentation

Data Grids
The user will notice that the Script Output grids now look and behave EXACTLY as the Data Grids produced with single statement execution and the data grids in the Schema Browser. Advanced datatypes are now also supported in the grids; you can now double-click on a CURSOR value for example and access Toad's Advanced PopUp editor for Oracle Cursors.

If you do not wish to have the data presented in the data grids, you can disable them by going to View-->Options-->Editor-->Display-->Script Output and un-checking 'Show Script Grids'.

Running History
Toad's Script engine now has an options History tab. In View-->Options-->Execute/Compile, simply toggle on the 'Maintain Script History' item. Toad will now keep all of your Script Output for your entire session in case you want to access the results for a statement or script you executed earlier. Also take note of the 'Show Script Start/End times' option which is also new for 9.0.

Layout and Presentation
The Script Output tab layout now has the Output and Query data grid tabs aligned together across the top of the display panel. The toolbar for the data grids now has the standard SaveAs button and the 'VCR' style navigation buttons. The Output tab with the normal text output (what you would see in SQL*Plus) is not a true editor, but you can select and copy the output line by line.

Toad will now also catch errors and display their location as encountered in the error popup dialog(s) and in the Output tab.

View the standard text or Toad's Grid output for all of your script executions!

Operation	v6-8.6	v9.0
Execute Statement (Editor contains 1 statement)	or F9	or F9
Execute Statement at Cursor	or SHIFT+F9	or F9 (with delimiters) or SHIFT+F9 (w/o delimiters)
Execute Multiple Statements	or F5	or F5
Compile PL/SQL Object at Cursor	or F9	or F9
Compile All PL/SQL in Tab	Not Possible	Mouse Right-Click in Navigator "Compile All"

The editor now supports multiple statements per tab. No longer will you need to separate all of your objects across many tabs just to compile. You can now compile, execute, and debug objects that are in the same tab. You are still able to open Package Spec and Package Bodies to separate tabs when opening Packages from the database.

Toad Editor Toolbars

The toolbars for the Toad Editor now include all of the items from the SQL and the PL/SQL Editor windows. To select which toolbars are visible on your Toad Desktop, right mouse-click on the main toolbar and select the toolbars you wish to be visible.

Toolbar Selector


Merged Toolbar

This is the default toolbar - all editor items are listed...by 'merged' we mean that all of the child toolbars are consolidated to a single toolbar. This is nice as you'll have all of your "More Buttons" available at the end instead of one for each seperate toolbar. This leaves more space for the actual buttons on the toolbar and should be easier to navigate.

You now have only two execute statement buttons. The first button on this toolbar maps to the 8.6 and previous 'Execute Statement' and 'Compile' actions. Next there's a new halt statement execution/debugging/data fetching button. Execute as script still has the lightning bolt icon, plus you also have a dropdown control for optionally running your scripts directly via SQL*Plus or QSR. Note: To execute an explain plan, you need to use the Ambulance button. Visiting the Explain Plan tab no longer automatically generates the Explain Plan.

This toolbar has buttons for switching connections, creating new tabs, loading from database or file, print, make and strip code, etc.

Has buttons for select all text, clear text, InitCap, Format, find, and replace.

The navigation panel has been greatly enhanced. Since the Editor supports multiple objects per tab, so does the navigation panel. The status and information for each object can be seen at all times, or if you want to conserve desktop space, you can hide the status columns and use the status panel which will show the same information for each object as you click on it in the navigation tree. You can right mouse-click on a PL/SQL object in the Navigator and choose to compile your objects or reload from the database. If you have a file loaded that contains PLSQL source for objects that also exist on the database then you have a Reload Object button on the toolbar to reload the source for the object at your caret. This way you can easily synch files to the source that exists on the database. If you cannot see the navigation panel in your Toad Editor, right mouse-click in the Editor, and select Desktop - Navigator to open it. To configure the layout of the Navigator, right mouse-click and select 'Navigator Panel Options.' You can dictate what level of detail information is displayed in the navigation tree, whether or not to group similar objects, or whether you want to alphabetize the list.

9.0 introduces an added dimension of editing with the highly anticipated code folding feature, which lets you collapse and hide portions of your code so that you can view more of the lines you need to see. Note in the image below, you can hover the mouse pointer over the plus sign or the first line of the folded code in order to see the hidden portion of code. You can then expand it when you need to work with the folded code.

Language management (see below) is the basis for code folding. Although some standard settings for code folding are included with Toad, the strength of this feature is found in the ease of configuration. You can set Toad to fold code where you want it to fold.

Arguably the greatest strength of the new integrated Toad Editor is its language management capabilities. You can set up Toad to parse any number of languages, including PL/SQL, Java, C++, HTML and others, including custom languages. Toad takes the language source, parses it according to the categories you've set up, then breaks it down into more manageable Tokens and Token types. It then applies the rules you have created, such as syntax highlighting properties and code folding, to make the Editor behave as you wish.

Managing languages has an effect on many areas of Toad; syntax highlighting is based upon defined command words, as is code folding and the Make Code functionality. The ability to set up sub languages means that you can define capitalization effects that apply only to your PL/SQL code, and not embedded Java, Perl, or other languages.

General Editor Enhancements

• SQL Recall via <ALT>+<UP>/<DOWN> will now replace selected text only or append to the contents of the editor. Before it would replace the entire contents of the active editor tab.
• You can now explicitly set the Syntax Parser language by right-mouse-click. This allows you to change from a PL/SQL based syntax highlighting scheme to a Java or HTML based one. It defaults based on file extension. Raw text in the editor defaults to PL/SQL based syntax highlighting.
• The Error Panel is no longer a dockable window. It has been restored to its pre-8.5 behavior and error panel now appears directly in the lower portion of the editor panel.

Debugging SQL Scripts vs Debugging Stored PL/SQL and Java

Now that the Procedure Editor and the SQL Editor have been merged, it's possible to have a single interface to Toad's powerful Debugging functionality. Toad has previously offered a Debugger for both your SQL*Plus scripts and stored PL/SQL code and is now additionally providing support for Oracle's JDWP debugger.

Debugging a Script which contains DDL for creating a PL/SQL object versus debugging the actual PL/SQL object code can have drastically different results. For example take the following text:

CREATE OR REPLACE PROCEDURE case2_proc (p1 IN OUT NUMBER) AS
n NUMBER;
BEGIN
n := p1;
p1 := n + 1;
END;
/

If a user were to use the Script debugger against this code, it would actually re-create the object in the database. If a user were to use the PL/SQL debugger, it would step through the actually lines of code for that object. Accidently using the Script Debugger could result in many of your database objects becoming invalidated, so the debugger buttons have different images depending on which debugger is enabled.

Under the Debug menu, there are 3 debugger types which can be selected:

• DBMS Debugger (Uses the DBMS_DEBUG package to debug your PL/SQL.) This is available in Oracle versions 7 - 10gR2
• JDWP Debugger (Uses the JDWP Java console to debug your PL/SQL or Java.) This is available in Oracle versions 9iR2 - 10gR2
• Script Debugger (Uses Toad's Script Debugging engine to allow you to step through your SQL*Plus scripts.) This is available for all versions of Oracle

This toolbar is activated in the Editor if you have Toad Professional or Toad Xpert and have selected the DBMS or JDWP Debugger.

This toolbar is activated in the Editor if you have Toad Professional or Toad Xpert and have selected the Script Debugger.

SQL Modeler--henceforth Query Builder--now reverse engineers existing SQL statements!

One of the most frequent requests over the years has been for a Query Builder that can accept SQL Statements and build a model. With the 9.0 release, this is now possible!

To reverse engineer your SQL you can either

1. Send it to the Query Builder directly from the Editor by right-clicking OR
2. In the Query Builder, you can open a .SQL file

You can now also easily convert your ANSI-SQL statements to Oracle-SQL statements and vice versa by using the Query Builder toolbar button toggle.

Enhanced Debugger

Toad has offered a PL/SQL Debugger for several years now. During that time, we employed Oracle's PROBE API interface via the DBMS_DEBUG package. This is an Oracle supplied interface to its internal PL/SQL debugging packages. Starting with release 9i or Oracle's RDBMS, the PROBE API is being phased out in favor of the Java based JDWP debugger package. Toad is now the only Oracle tool on the market that supports both interfaces.

Why would I want to use the JDWP debugger?

If your job requirements include development and debugging of Java Stored Procedures, Toad can now assist you with its support for the JDWP debugger.  Enabling JDWP debugging in Toad will allow you to trace from your PL/SQL code into a Java Stored Procedure, set watches or breakpoints in your Java code and execute Java statements stepwise during execution. Plus, JDWP also provides the same functionality for PL/SQL debugging.

Should your work only involve PL/SQL development and you wish to avoid the processing overhead inherent in JDWP debugging, Toad's standard DBMS Debugging functionality is still available to you.

How to Get Started with the JDWP Debugger

Toad will default to using the old DBMS_DEBUG interface for debugging. To debug with Java, enable the 'Use JDWP...' option. After setting this up, your debugging experience will mirror what you have seen before with Toad. You will still use the 'Set Parameters' window to initialize the execution of your object and you can begin debugging. Except now, you'll be able to step into Java code, or start out in Java code and step into PL/SQL. You will need to have the "DEBUG CONNECT SESSION" privilege granted to your user account, and your code will need to be compiled with Debug. Without this your code will not be able to be debugged. Note: You can now also profile your JDWP debugging sessions with Toad's Profiler.

CodeXpert Face-lift

If you have not used CodeXpert before, now is a great time to get started. For the 9.0 Release, the CodeXpert engine has been tweaked and the user interface has been greatly improved. Here are the highlights:

• A new standalone screen for working multiple objects and files is available
  • Has a CMD-Line interface with HTML output for easy scheduling
  • Send objects or files from the Schema Browser, Object Search, or Project Manager
• The CodeXpert Tab in the Editor is easier to navigate
• It's now easier to customize rule sets

	Remember, CodeXpert analyzes code against a set of rules for best practices. Quickly generate code metrics, identify poorly written SQL or PL/SQL, and generate CRUD Matrices to immediately see how your code touches the data in your database.
Click here to see a video of CodeXpert

New CodeXpert Standalone Window

If you want to harness the power of CodeXpert and use it analyze all of the objects in your database or scan all of your PL/SQL source code files, then you will want to open the main CodeXpert window under Database-->Diagnose-->CodeXpert.

Once you have the window open, you can automatically load all of the objects for a given schema, or open multiple files from a directory.

You can also send files or database objects to the CodeXpert from the Project Manager, the Schema Browser, and the Object Search windows in Toad. After Toad scans the objects, you are able to view the output for all of your PL/SQL in a nice, easy-to-read grid or view HTML reports for each individual object.

You can also schedule to have the CodeXpert analysis produced at regular intervals by mouse right-clicking in the window and selecting 'Create Command Line Paramater File.'

New CodeXpert Window
Click here to watch a video

Brand New Toad Reports Interface

Toad has offered its 'Toad Reports' reporting tool for many years. With the 9.0 release, Toad users will now be able to take advantage of the powerful FastReports interface introduced in the 8.6 release coupled with all of the pre-canned reports that Toad provides.

Let's get started!

1. Go to Database-->Report-->Reports Manager
2. On the toolbar, hit the 'Import Report Definition" button
3. Navigate to your \User Files\Reports\Samples folder.
4. This will build out a series of categories on the Left Hand Side (LHS) of the screen.
5. Pick a report.
6. Fill out any appropriate bind variable values in the 'Value' box on the RHS.
7. If a SCHEMA or other database object needs to be inputted, use the ellipsis button to bring up a list of available selections.
8. If there are any Detail data sets or additional query tabs for the report, navigate to them and fill out the appropriate information for your report.
9. Add any comments you want to the 'Comments' tab.
10. Click on the 'Design Selected Report' button on the toolbar.
11. Make any report layout changes you wish to implement.
12. Save the Report (not necessary if you make no changes).
13. Close the design view.
14. Click on the 'Preview Selected Report' button on the toolbar.
15. You now have your report! You can now print, mail, or export your report to the format you wish.

Watch a video demonstration.

Now, when a user wants a User Summary Report, they will be able to run it AND customize the content and format of the report PLUS change the query used to build the report. The FastReports engine allows the user to add detail data sets, insert graphs, add custom images, and control every aspect of the presentation of the report.

Report Printing or Exporting From Command Line

To set it up, follow these steps:

1. Open the Editor, enter your query and design your report against it. Save the report definition to a .fr3 file.
2. In the lines before or after your query, enter the following:
   • ReportFile:full path to your .fr3 file
   • Print (if you want to print)
   • Save To File:full path to the export file you want to create
   • CloseToad (if you want Toad to close when you are done)

   The supported 'save to file' extensions are: HTML, PDF, TXT, XLS, BMP, RTF, JPG, GIF, and CSV.

3. Save your query with the lines you added to a file.
4. To run from command line, call Toad like this: c:\toad\toad.exe connect=scott/tiger@orcl rep=c:\your_query_file.sql

With a command-line interface to reporting, you can now schedule Toad to generate your daily reports for you!

Schema Browser Enhancements

Toad's most popular window should now be even more powerful and easier to use in version 9.0. Here's a list of the highlights:

• You can now filter your Schema Browser objects lists by Project Manager Project files. Basically you can tell the Schema Browser to only show you objects that are in specific projects.
• You can now customize the Right Hand Side tabs of the Schema Browser by right-clicking on the RHS tabs.  You can also hide the RHS completely with F12 (Hit F12 again to bring it back). Doing so will make the browser skinnier and skip a lot of queries as you click around on the left.
• The PROCS Schema Browser tab has been split into 3 separate tabs, Procedures, Functions, & Packages.
• The background color of the Schema Browser panels can now be adjusted from Options, Schema Browser, Visual.
• An "Invalid Objects" tab has been added to the left hand side. It also includes unusable indexes (or indexes with an unusable partition or subpartition). It works like the synonyms tab - the right hand side assumes the form of whatever object type is selected on the left. The LHS has a special popup menu for invalid objects, and the RHS has object-type specific popup menus.
• Tables (LHS), Constraints (RHS): A grid has been added that lists all constrained columns for the table. The columns could be part of any kind of constraint. A checkbox has been added that when checked will filter the constraint listing by the selected column.
• RHS Columns tabs - an option has been added to copy the column names in a column format (options - Schema Browser)
• SB-Tables-Referential Rewritten. Features include:
  1. Information is now displayed in columns, so you can sort (within the tree hierarchy) by each column, or perform an incremental search (ie, type a letter on the keyboard and that row will be located).
  2. Columns can be enabled or disabled by right-clicking on the column header. Columns can be reordered.
  3. Column visibility, widths, and order will be remembered.
  4. Hit F4 over a table name (or constraint name) to describe the object.
  5. Right-click to print or copy to clipboard
  6. "Compact mode" checkbox will show minimal info in one column.
  7. By default, full details of each constraint are shown when you pause your mouse over a node in the tree. If you prefer to see just the text in the node as a hint, uncheck "Detailed Hints".
  8. The text "recursion detected" (to indicate recursion in foreign keys) has been replaced by an icon (circular arrow).
• You can now filter the data grids for objects by Partition on the Filter dialog.

New Explain Plan

For version 9.0, Toad is introducing a visual Explain Plan. No more trying to read complex and confusing default explain plan layouts. To view a plan in the Editor, use the Ambulance Toolbar Button to get the execution plan for your statement. You can then view your plan in several different formats, including an animated one. You can also Compare your plans, EXPORT them to XML, PRINT, or COPY them!

Click here to see a video of the Explain Plan.

RAC Enhancements

For 9.0, Toad is bringing even more of a RAC-centric view to its Database Administration monitoring and diagnostic tools.

Toad and RAC Refresher

Oracle's RAC technology lets you start an Oracle instance on multiple servers, and have all those instances open the same shared database (or shared set of data files). In this way, you can scale the size of your database server by adding more computers as you add users. Toad initially introduced support for Oracle 10g's RAC technology in the 8.5 release in 2005.

Additional Information for RAC Connections

When you log into a RAC connection, Toad notes this fact and makes additional information available in some of its windows to help you manage that connection.

Captions

If a RAC connection is in effect, the caption of the Toad Main window will reflect this by showing: TOAD: RAC[n], where n is the session id.

Connection bar

In the connection bar, RAC connections are listed as SCHEMA@RAC[n], where n is the instance number of the connection.

Enhancements for 9.0

• Top Session Finder
  • Added RAC related fields
    • -FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER (Oracle 8.0 and newer)
    • RESOURCE_CONSUMER_GROUP (Oracle 9i and newer)
    • SERVICE_NAME, WAIT_TIME (Oracle 10g and newer)
• For RAC, the following windows now support using either the GV$ views as before, or the regular V$ views:
  • Database Probe
  • Database Monitor
  • Session Browser
  • SGA Trace
  • Top Session Finder
• DB Monitor
  • When connected to RAC, you can now choose which instance to monitor
• Top Session Finder and SGA Trace can now operate against individual RAC instances or ALL RAC instances

Top Session Finder Against All RAC Instance

Database Monitor with RAC Instance Picker

SQL*Loader Wizard Enhancements

Toad offers a full lineup of utilities and tools that allow an Oracle professional to extract data from the database and load data back into the database. In the last several releases, Toad has introduced:

• Export File Browser
• DataPump wizards
• Text, XLS, & Access .mdb Import Wizard

When working with large amounts of raw data in text files, Oracle's SQL*Loader utility is the most robust tool available. Unfortunately, it's a bit intimidating out of the box and does not have a Wizard interface. Toad adds value by providing its own interface for SQL*Loader, and that interface has been completely re-designed for 9.0.

Note: The SQL*Loader wizard is available at Database-->Import-->SQL*Loader Wizard.

Here's a list of highlights:

• Specify fields and map them to table columns
• Save and re-load SQL*Loader frequently used settings profiles
• Click to manually define column definitions, or specify delimiter characters on the fly
• Watch Toad dynamically build your SQL*Loader control (CTL) file - learn SQL*Loader with Toad!
• Now supports the majority of SQL*Loader's options

As before, you can also use Toad to create SQL*Loader control files with the DataGrid -->SaveAs screen AND schedule your SQL*Loader sessions to run at any time.


Use a delimiter character OR


Manually define your column positions.

SQL Tuning and Optimization Updates

Plan Change Analyzer

The Plan Change Analyzer tracks execution plan and Oracle cost changes for multiple SQL statements. It allows you to perform What-if analysis of index creation, database configuration changes, Oracle database migration or new deployments, and more.

Cross Index Analysis

The Cross Index Analysis engine analyzes a set of SQL statements and determines the best common index for all of the selected SQL statements. The previous index advice engine was replaced with a more powerful artificial intelligence engine.

Index Impact Analysis called from Cross Index Analysis and SQL Optimization Console

After Cross Index Analysis provides index alternatives for multiple SQL, or index alternatives are provided by Index Expert in the SQL Optimization Console, Impact Analysis can be launched.

The new Index Impact Analysis function in the Plan Change Analyzer allows you to simulate the impact of creating new indexes on other SQL statements before the physical indexes are created.

Tutorial Chapter

Added a tutorial chapter to the online help with step-by-step instructions for each module.

Oracle Privileges Script

A sample Oracle script for granting privileges to SQL Optimizer users is included in the online help.

Optimization Hints Quota

Changed the way the Hints Quota value is used in the optimization process to enable you to have more permutations when a SQL statement contains several SELECT statements.

ADDM/AWR

Oracle's Statspack for gathering and monitoring performance metrics has evolved into the 10g Automatic Workload Repository (AWR). Toad's DBA module for version 9.0 has full support for AWR.

Oracle's built-in automatic advisory and tuning technology, Automatic Database Diagnostic Monitor (ADDM), is fully supported in Toad via the DBA Module for version 9.0.

Toad introduced support for Oracle's ADDM interface in the 8.6 release. For 9.0, it's been GREATLY enhanced and renamed. The new name is ADDM/AWR and is now available off of the Database -->Monitor menu flyout.

Note: AWR usage requires valid Oracle license for the Diagnostics Pack.

New Reports:

• AWR (Both text and HTML formats)
• AWR SQL (Both text and HTML formats) Requires Oracle 10GR2.
• AWR Diff (Both text and HTML formats) Requires Oracle 10GR2.
• ASH (Both text and HTML formats) Requires Oracle 10GR2.

New Features:

• Snapshot Manager (view stats/create/delete)
• Baseline Manager (view/create/delete)

---

Tip: Use the Baseline manager to create Snapshot range baselines for quickly running your reports without needing to manually specify your start and stop times.

Tip: Make sure your user account has execute privileges on the SYS.DBMS_WORKLOAD_REPOSITORY package.

---

ASM Support

ASM is an Oracle 10g technology that allows DBAs to manage their file systems and volumes regardless of the hardware or OS implementation. Go here to read more about ASM.

Toad's DBA Module is being enhanced in the 9.0 release to support 10g's ASM technology. New Menu item, Database-->Administer-->ASM Manager. From there you can view

• diskgroups
• disks
• templates
• files
• aliases
• current operations
• clients

You can also Create, Alter, and Drop diskgroups. Both 10g Release 1 and 2 are now supported.

Odds and Ends

Here is where we list all of the other cool stuff you may want to know about the 9.0 release.

• SQL*Plus HOST command support enhanced. If you do a "HOST DIR C:\" or similar command, the output will go directly to the Script Output panel in-line with the rest of your Script Execution results.
• You can associate an Oracle_Home (Oracle Client installation) for your connection history items.
• Command Line - you can now add MINIMIZE=YES to the command line to make TOAD minimized during any command line operation
• Create Table - There is a new "Create Cols From File" button. The button lets you read column names out the first row of an excel or delimited text file, or from an MS Access table.
• Top Session Finder - Locate your session in the Session Browser.
• Toad now has a 'throbber' - indeterminate status bar - now displays for many lengthy operations and lets you know Toad is working on something.
• You can now set a different directory from which to load your user files (current default is \User Files). Options > General > User Files
• Passwords are now stored in an encrypted file, CONNECTIONPWDS.INI. Note: this file is tied to the volume on which it resides. It can not be used on any other volume or any other machine. If an attempt is made Toad will raise an error.
• Single Record View now has a Print Button.
• Find in Files - completely rewritten with significantly more functionality, including Date range searches, file attribute and size searches and regular expression support. The Text to find and File masks persist across Toad sessions, the output window search results tab preserves the caption of the string searched for. Overall, it is much, much faster as well.
• Table Data Duplicates renamed to Data Duplicates and supports Views and Snapshots now in addition to Tables.
• For all File Open/Save dialogs, a Favorites/History control is now available so you can easily work with your favorite directories without having to manually search for them.
• Project Manager nodes now have a 'Note' property. You can configure them to appear as hints if you mouse over the object.
• Login Window now allows for Custom Colors for your connections.

---

For questions or comments on this site: webmaster@toadsoft.com
All content Copyright © 2006 Quest Software, Inc. All rights reserved.