TOAD Quick Guide

General Shortcuts
Schema Browser Window
Using Favorites
Procedure Editor and Debugger
SQL Editor Window
Data Subset Wizard
Using Auto Replace
Project Manager Tutorial
Action Palette or Application Designer (Save repetitive actions like a macro)
Action Console
Object and Schema Compare
Statspack and AWR Browser
Data Import / Export Browse
Trace File Browser
Code Expert
Database Browser
RMAN Script Templates
Data Generation
Rebuild Multiple Objects
SGA Trace Optimization
Run TOAD on a USB Drive
Other Good Tools
Resources Collected
Download....

Toad for Oracle Editions 
As you may already know, there are different editions of Toad for Oracle:
 

Does Toad need OEM ?
Toad offers optional features in the DB Admin Module (under Database/Monitor) which WILL ACCESS the Oracle OEM Diagnostics Pack such as :
  1. ADDM/AWR Report Generator – enables snapshot management and shows both AWR and ASH reports
  2. AWR Browser – graphical representation of data collected from AWR
  3. ASM Manager – enables management of ASM disk groups and clients
Toad does offer alternate ways to determine performance bottlenecks without the use of ADDM/AWR such as the StatsPack Browser, TK Prof interface, Database Monitor, Session Browser and the Quest SQL Optimizer’s SQL Inspector to name a few. However, if you are already licensed to use the OEM Diagnostics Pack and you wish to get additional value from it, you can use the functionality we offer in Toad.
If you are on Oracle database 10g and above, you can use the Oracle Tuning Advisor feature in Toad Base (9.6 and higher) which WILL access both the Oracle OEM Tuning Pack and Diagnostics Pack.
Alternatively, you could use Toad Xpert, Development Suite or DBA Suite Editions and use the Quest SQL Optimizer which DOES NOT access any of the Oracle OEM Packs at all. In addition, Quest SQL Optimizer offers a unique way to rewrite your SQL code for maximum performance.


TOAD DB Module

Screen Shots of its content:

Database - Administer - Compare and Import Options


Database - Optimize - Diagnose - Monitor Options



General ShortCuts
ACTION KEY
Schema Browser F2
SQL Editor F3
Describe an Object (also CTRL+Rigth Click). Just  put the cursor over the object
 F4
Execute code as Script (from SQL Editor) F5
Jump to that Object (Browser Window) SHIFT + F4
Toggle between SQL Editor and Results tabs F6
Clear all text (from SQL Editor) or Trace Into on the Procedure Editor F7
ReCall SQL History (opens the SQL Statement Recall panel)
 F8
Display Previous/Next Statement used ALT + Up or Dn
Provides a Code Template  (with Rigth Click - Editing Options - Code Templates I can edit them) CRTL + Space
Run Statement (from SQL Editor) or Compile (on the Procedure Editor). Execute all statements in the Editor F9
Verify statement without execution (parse) CTRL + F9
Run Statement at Cursor SHIFT + F9
Execute as script or Run (continue execution) in the Procedure Editor for PL/SQL debugging F11
Run to cursor in the Procedure Editor for PL/SQL debugging. F12
Convert Text to Lowercase / Uppercase
 CTRL +  L / U
In the data grids, goes to the TOP/END of the recordset CTRL + HOME or END
Clicking on a procedure/function name while holding the <CTRL> key takes you to the place where that name is defined. <CTRL>Click on identifier
Moves to the selected procedure in the body from the spec (up or down)
 CTRL + SHIFT + UP or DOWN
Completion dropdown. As you type the procedure name, the dropdown does an incremental search in the list. CTRL .
If you begin a procedure call and pause after the first (, Toad parses the procedure spec and gives you parameter hints. You can cycle through parameters for overloaded functions. (
Execute Explain Plan on the Current Statement  CTRL + E
Recall Named SQL Statement CTRL +  N
Columns Dropdown  CTRL + T
Navigate to the next results panel tab CTRL + ALT <PageDOWN>
In the data grids, goes to the top  / End of the recordset CTRL + HOME or END
Completely expand dependency tree views CTRL + SPACE

 
Schema Browser Window
You can see tons of objects over here.
For each object you can generate its DDL, see Used BY, check stats, indexes, constraints, etc

For Table Data you can:
•  Create Insert for All Rows
•  Create Insert statements replacing values (example use sysdate for dates, sequences, etc)
•  Save as HTML Report
•  Generate very nice reports
•  Detect Duplicate Rows
•  Record Count
•  Perform Multi-Select and then work with those rows only
•  Find Data
•  View/Edit Query
•  Create in Another Schema
•  Compare Data
•  Rebuild Objects
•  Master/Detail Report

For Code
CodeXpert to provide Tuning in your code


Using Favorites as a Custom Schema Browser
Often in TOAD, you need to work with the same group or groups of objects. For example, you might only need to routinely work with the production tables for CUSTOMER and EMPLOYEE, their indexes and views. So you would like to have a customized Schema Browser for just those objects. TOAD offers the Favorites tab so that you can easily and quickly work in this manner.
It can be a huge productivity enhancer. You can group your DB objects by different folders.
Once you created your folders, you need to browse to your favorite DB object, rigth click on it and select "Add to SB Favorites List"


Procedure Editor Window and Debug Menu
First of all, some concepts:

Debugger Shortcut Keys
ACTION
 KEY
Set or Delete a Breakpoint on the current line SHIFT + F5
Add watch at cursor CTRL + F5
Trace Into SHIFT + F7
Step Over SHIFT + F8
Display mouse right-click popup menu
 F10
Trace Out SHIFT + F10
Compile F9
Execute Current Source SHIFT + F9
Set Parameters SHIFT + CTRL + F9
Run (continue execution) F11
Run to Cursor F12
Display Breakpoints
 CTRL + ALT + B
Display DBMS Output
 CTRL + ALT + D
Evaluate/Modify
 CTRL + ALT + E
Display Watches
 CTRL + ALT + W


Rigth-Click Menu

The Toolbar for Debugger


From left to right:
• The lightning bolt is the Run button. This button will execute the procedure in debug mode.
• The (...) parameter allows you to set any IN variables to the package and/or procedure.
• Next is the Step Over button, which allows you to walk through the PL/SQL code one line at a time. This button will skip any procedures that are called.
• The fourth button is the Trace Into button. Both this button and the Step Over button walk through PL/SQL code one line at a time, but Trace Into will enter any called procedures or functions and execute that code one line at a time.
• Next is the Trace Out button; it exits Trace Into code.
• The sixth button is the Run to Cursor button. This is an alternative to setting breakpoints. PL/SQL is executed until it reaches the line where the cursor is, and then halts execution much like a breakpoint.
• The hand button is the Halt Execution key, and it will stop execution of the PL/SQL routine retaining watch and breakpoint settings.
• The eyeglass button allows you to easily set watches on variables where the cursor is located.
• The final button compiles the entire procedure call tree for debugging.


Some notes on Debugger
If you have OUT or IN OUT arguments in your procedure, you can elect to view their values during debugging in the Debug DBMS Output window.
To accomplish this, check the “Output OUT Args” check box on the “Execute Procedure/Package/Trigger” dialog.
TOAD will automatically add DBMS_OUTPUT.Put_Line statements at the end of the anonymous PL/SQL block used to invoke your procedure.
Turn on the Debug DBMS Output window from the “Debug” menu, or press CTRL + ALT + D


Setting breakpoints/visualizing variable contents
Breakpoints suspend the execution of the code. This allows you to view the contents of various variables.
You could set the breakpoint by simply clicking to the left of the Procedure Window.
Notice that the Break Points tab at the bottom shows the line location of the breakpoint. To work this code, click where the breakpoint is desired and then press the Run button. This will invoke the debugging routine and suspend code execution when the breakpoint is reached.
After the code is suspended, you can check the contents of variables and implicit cursors. The line with the breakpoint set is now highlighted in blue. Simply place the mouse cursor over a variable or cursor and the contents will pop up after a second or so.


Watches
A watch in TOAD allows you to watch the changes to variables as the code is executed. You can also change the contents of a “watched” variable. Watches are easy to set.
You can highlight the variable and press the Add Watch button on the Watch tab (the Ins key is the TOAD hot key).
You can also right-click on the highlighted variable and select Debug | Add Watch at Cursor.
Any of these options will add the variable to the Watch tab.
You can also modify the value of a variable that is watched to force a special situation.

Conditional breakpoints
TOAD allows for breakpoints to occur when the process has performed certain events (such as looping x number of times) or when a certain data condition exists.
This is easily accomplished by first setting the breakpoint. Click to the left of the Procedure Window, and then right-click and select Debug | Set Breakpoint). Then, go to the Break Points tab, highlight the breakpoint for which you want to define a condition, and press the Edit Breakpoint button (the leftmost button).



SQL Editor Window

ACTION
 KEY
Windows Help File F1
Toggle Output Window Figure F2
Toggle Data Grid Window Shift + F2
Find Next Occurrence F3
Find Previous Occurrence Shift + F3
Describe Table, View, Procedure, Function. Just  put the cursor over the object F4
Execute SQL as a script F5
Toggle between SQL Editor and Results Panel F6
Clear All Text F7
Recall Previous SQL Statement F8
Display Previous / Next Statement Alt + Up / Down
Execute Statement F9
Set Code Execution Parameters Ctrl + F9
Execute Current SQL statement at Cursor Shift + F9
Pop-up Menu F10 or right-click
External Editor, Pass Contents Ctrl + F12
Execute Explain Plan on the Current Statement Ctrl + E
Goto Line Ctrl + G
Convert Text to Lowercase Ctrl + L
Make Code Statement Ctrl + M
Recall Named SQL Statement Ctrl+N
Open a Text File Ctrl + O
Strip Code Statement Ctrl + P
Columns Drop-down (show objects owner by user)
 Ctrl + T
Alias Replacement Shift + Ctrl + R
Columns Drop-Down no alias Shift + Ctrl + T
Code Templates Ctrl + Spacebar
Converts Text to Uppercase / Lowercase
 Ctrl + U / L
Display Pop-up List of Matching Table Names Ctrl + .
Redo Last Undo Shift + Ctrl + Z
In the data grid: goes to the top  / End of the record set Ctrl + Home / End
Cycles through the Collection of MDI Child Windows Ctrl + Tab


SQL Editor Shortcuts
         1. If you have long column/table names and do not like typing them out each time, then you can use our auto complete feature. Type in a portion of the table or column name, for example “ow_cu”, and then press Cntrl + . (period). Toad will automatically identify the name of the object and fill in the rest of the word to read “ow_customers”. If there is more than one object that satisfies the string “ow_cu”, then Toad will bring up a list of all the possible objects and you can select from there.
            
         2. Everyone should be aware of SQL Recall Feature (F8) which brings up previously run select statements. If you want to quickly list old statements that you ran minutes ago, then in the editor press Alt + Up or Down arrow key and it will toggle through your SQL Recall list. This saves you from opening up the Recall list and scrolling down to find the SQL you want. You can keep the focus in the editor and toggle through with this hot key.
            
         3. If you are constantly mistyping words in the Editor, then let Toad fix your spelling errors automatically. Right click in the editor and select “Editing Options”. On this new option screen click on the “Auto Replace” button in the bottom right hand corner. Here you will see a list of the common misspelled words our user’s experience. If there are words you constantly misspell, then you can add them to the list by using the “Add” button. So, now in the editor if you mistype the word “select” as “seelct” … it will automatically fix itself once you hit the spacebar.

          4. If you keep the Ctrl key pressed and click over a procedure/package name, that code will be opened on another TAB. If you do it over a TABLE, it will desc that table.



Explain Plan
This option is very helpful to identify the access path of a SQL Statement.
You can get the Explain Plan from the SQL Editor, the Database | Monitor | SGA Trace Menu option (for Items in memory) or from the Session Browser.
Once the plan is generated you will get a menu like this:






Data Subset Wizard (Tools Menu)
This window lets you copy a portion of data from one schema to another while maintaining referential integrity, so that you can work with a smaller set of data.
The wizard creates a script that will copy a specified percentage of data beginning with all parent tables or from all tables with no constraints. You can specify a minimum number of rows. The wizard then continues with tables that have foreign key constraints, the rows copied are those whose parent rows have been copied into the parent tables.
The wizard consists of four screens which allow you to set options as follows:
Screen 1: Select source and target connections/schemas and specify where to save the script.
Screen 2: Select Objects to create in the script.
Screen 3: Set up the commands in and around the insert statements.
Screen 4: Set up any extents or tablespaces when the wizard is set to create objects.


Using Auto Replace
Toad allows easily add your own commands or give simple keystroke access to your commonly-used coding techniques.
Auto Replace is used to correct typo’s and to save you time.
To set up this option go to Edit -> Editor Options, Click on Auto Replace and you will see the existing Auto Replace options.
I entered the following options:
Sf       select * from
Pl       DBMS_OUTPUT.PUTLINE

So if I type pl followed by the space bar, it will be changed by DBMS_OUTPUT.PUTLINE


Project Manager Tutorial
Most IT professionals do not live exclusively in the Oracle database. Instead, they are using the power of the Oracle database to provide information to their custom web pages, applications, batch jobs, and much more. So someone using Toad to access the database is most likely also using spreadsheet, web development, word processing, and other applications. Toad's Project Manager provides a centralized area for the user to manage ALL of the items for a given application, task, or a project. This could be a collection of tables, stored procedures, database jobs, ftp folders, web pages, documents, etc.

For example, I have a project labeled TOADSOFT. I can use the PM to manage everything I need


Here you can see my project for managing QUEST content.
The QUEST project contains a node for the remote server where the site is hosted, a link to my Desktop and some files I need to frequently edit and find easily, Oracle tables I need to update for posting the Release Notes, URL's I need to keep an eye on, and a link to the folder where I keep a backup of all the web content.
I also have another project I use to manage the Beta release. I can zip up the files for the beta and DRAG-N-DROP the file to the Web Server to easily FTP the file.

How do I Add Something to a Project?
If you have already found your database object using Toad, you can easily add it to your project. You can mouse-right-click on the object in the Schema Browser and choose 'Add to Project Manager.' You can also add objects from Toad's Object Search dialog. It's important to remember that you can select MULTIPLE database objects and add them to a project simultaneously. If you have more than one project open, Toad will prompt you to choose the project you want to add the object(s) to.
To see just how powerful the Project Manager really is, bring up the options dialog by pushing the options button on the PM window. In the PM, we can configure what happens on Double-Clicks, R-Clicks|PopUps, and Drag-N-Drops.
Project Manager works in exactly the same way as the Schema Browser. In particular, the right-click context menu is identical, and you get the same display on the right if you select an item.
You can also create a REAL Directory, and if you drag and drop a table name over there you’ll find an actual file with the DDL to create that table and all of its supporting structures


Action Palette or Application Designer (like a macro)
Open the AppDesigner window from the Utilities | AppDesigner.
A database developer or database business analyst might need to do something in Toad related to the data content, and then repeat or schedule that task, instead of doing over and over again, you can use the APPDesigner. The AppDesigner feature allows Toad users to create “mini-applications” within the App Designer, and schedule these tasks.
The Appdesigner is broken into three main areas:
As an example:
I open Toad Editor, enter my query, and press Execute to make sure it works as intended. Then I right-click anywhere on the data grid and choose Save As from the context menu. On the Save as screen, I choose my options and parameters and click OK to verify that it works correctly. Then I reopen the Save As dialog; this time I click the camera icon at the bottom (or the lightning bolt on pre Toad 9.7 located by the minimize buttons). That opens a dialog for creating (but not running) a user-defined “Action” to perform this task.
I can now choose to run or schedule that application. If I choose to run it, Toad is simply executing the application within my currently running instance of Toad. That is, behind the scenes, it will execute the query and perform a Save As, but I won’t see anything flash by; I’ll just see a run status indicator such as the green Completed bar.
I can schedule that task to be performed periodically.
So where can you do this? Basically on any screen that has the yellow lightening bolt icon or the camera icon at the bottom, and the number of those screens is growing as we speak

Another example:
Most of the users love to use the “Save As” function in the right click menu for the data grid. But sometimes the user has to run the same query numerous times and repeat the steps to save the data off to the file format of their choice, that is a good example of using the Action Palette. 
Run the query in the Editor. And then right click on the data results and select “Save As”.
Continue to select your file format, and any options you want. Also remember to set a destination location for the new file.
Once completed, on the top right hand corner of this window, click the little yellow lightening bolt icon.
This will prompt you to give this action a name. Please provide a meaningful name and hit OK.
Under the View Menu, select the Action Palette option. This will bring up the Toad Action window.
Located in this window will be the new Action you just created. On the top of this window will be a “Schedule” icon underneath the green triangle icon.
Click on this and you can schedule the data extraction.
Just keep in mind that this is using Windows Task Scheduling to setup the job and you must have Windows up and logged in. You do not need to have Toad running in order for this to work. Now sit back and enjoy, while Toad automatically exports data for you to your desired location and in your desired file format.

Good information over here:
http://toadsoft.com/oravids/IntroductionToActions.htm
http://toadsoft.com/oravids/ActionsFromToadFeatures.htm
http://toadsoft.com/oravids/SharingAndSchedulingActions.htm



Action Console
What is the action console? Simply put, anywhere you see or work with an Oracle object in Toad, simply do a mouse-right click on it and the Action Console will give you Toad's FULL arsenal of action items for that object. ALL the power of Toad in a simple RightClick: Add Column, Constraint, Indexes, Analyze Object, Truncate and many more!!!



Object and Schema Compare
Perhaps one of the most popular Toad features for developers and DBAs is Schema Compare and Sync. 
With the DB Admin Module, you can also use schema definition files and perform synchronizations.
Schema Compare & Sync have been made actionable, and are available from the AppDesigner, or from the Window Snapshot button.
There are two ways to perform a Schema Compare using Toad:
   1. Using information stored in the Oracle Data Dictionary
   2. Using native Toad Schema Definition files.
The first method uses “brute force” to obtain the DDL information pertaining to every object in each compared schema.
The second method uses what are called Schema Definition (or schema snapshot) files. These files are encrypted, compressed files which contain all the information about every object in a schema at a particular point-in-time. The real beauty of using these files is that, not only are they an accurate record of what a schema looks like at a particular point-in-time, but when used to perform a schema compare using Toad, they take a fraction of the amount of time to process. What would take minutes to process using a data dictionary compare only takes seconds using this method.

In addition, Schema Compare has been expanded for easier use. You can now add multiple target schemas to compare, while still being able to switch between two schemas. In addition, you can use either a live connection to a database which loads all DDL information as you go, or schema definition files. These files are encrypted, compressed files containing all the information about every object in a schema at a particular point in time. You may want to use a schema definition file to run a time-sensitive comparison, but something additional is that when they are used for a schema compare, they take much less time to process.


Statspack and AWR Browser
The Toad StatsPack Browser (DBA module required) takes beginning and ending snapshots of database performance statistics and then offers graphical trending and time-series analyses based on those stats. The result is a gallery of useful charts for interpreting database performance.
+




It also contains advisories.
When two snapshots are selected (not checked, but selected), the Advice tab will give some info about the top wait event during the selected interval. Another way to display the advice is to double-click blue underlined waits in the top waits grid.




Data Import and Export
One of the most common development and test database tasks is to refresh data for users to run their code against. For this, many developers use the Oracle import and export utilities. But you really cannot see into a dump file, other than to ask for a table of contents.
Toad solves this problem with the Export File Browser, which is available by selecting Database | Export | Export File Browser.
Once you oopen your dmp file, I can view the contents of the dump file via the navigator tree view on the left side. I can also see the DDL for that object and its data under the tabs on the right side as well, so I can cut and paste the DDL to make sure the objects exist before the import.
Another handy tip: I can also see the data in a standard Toad data grid. This means I get all my right-click menu options such as Save As, Print, and Row Count.
Note that the Export File Browser must access the dump file to perform its job, so the file must reside on your PC (remember, Toad has a built-in FTP tool).


Trace File Browser
Oracle trace files have historically been difficult to examine. The Trace File Browser provides a way to display this information in a manner that is easy to read and easy to navigate so that problem areas can be quickly isolated.
The new Trace File Browser (under Database | Diagnose | Trace File Browser) provides far more information than was previously possible. In addition, after you have browsed a Trace File, a Benchmark Factory project file can be pushed to Benchmark Factory for workload replay.


Code Expert
What if you’re a DBA trying to track down a performance problem somewhere in the millions of lines of PL/SQL code in your database? Toad has a batch mode interface in Code Xpert designed for that very purpose. It scans the code and highlights line that needs attention—finding the proverbial needle in the haystack for you.
Just Select Database | Diagnose | Code Expert , Load your objects, select the ones that you want to Review and you are ready to go


Database Browser
There have been some major enhancements to the Database Browser. You can now use it as a central point for your database administration. As before, you can navigate to every database simultaneously, and drill down into any of them to administer database and schema objects.
Now you can right-click on a database node and perform a number of additional administration operations. You can go directly to the:
    * Top Session Browser for the selected database.
    * Session Browser for the selected database.
    * DB Health Check on the selected database.
    * AWR Browser
    * Generate RMAN Scripts
    * And many more...



RMAN Script Templates
Oracle RMAN scripts can be challenging and time consuming, especially for less experienced DBAs and they wanted an easier way to create and maintain scripts. Toad 9.7 supplies basic scripts that can be copied, edited and stored for re-use. Also, Toad variables can be embedded into the RMAN script.
You can edit existing RMAN scripts and add and delete scripts to and from the scripts list from the Options | RMAN Templates page.
You can then generate RMAN scripts from the Database Browser.
   1. From the Database Browser, select the database where you want to execute the script.
   2. Right-click and select Generate RMAN Script and select the script you want to generate
   3. Enter any required variables and click OK. The script will open in the Editor window, where you can then save or execute it via F9. Executing will open and run RMAN outside of Toad, and then close independently.


Data Generation
New to Toad 9.7 professional is a feature that provides a way to generate test data for your schemas and tables. Video with Demostration
Data generation is implemented in the following locations:
    * Schema Browser Left Hand Side (Object Panel) - right-click and select Generate Data.
    * ER Diagram - Click the Data Generation button:
    * Create Table window- Click the Generate Data tab.
In particular, you can specify:
    * The number of records to create
    * How to handle constraints
    * How to handle Referential Integrity
    * How to commit your work


Rebuild Multiple Objects
In TOAD you have an option to move several objects to other tablespaces. It's as simple as:


An then Select the objects that you want to move



SGA Trace Optimization
You can use the SGA Trace / Optimization command to view information about SQL statements that have been executed and the resources they used. Whereas Auto Trace and TKPROF information is specific to a single statement, SGA Trace Optimization displays statistics from multiple SQL statements currently present in Oracle's SGA (System Global Area).
Go to Database -> Monitor -> SGA Trace Optimization to open the SGA Trace window. You can set several options from this screen in order to search for SQL statements. The default settings are for ALL Statements for ALL Users, but you can click on the corresponding drop-down box and choose another option to change these choices. You can limit the selection to a single statement type (e.g., SELECT statements, UPDATE statements, anonymous PL/SQL, etc.) or to a specific user. You can also enter a text string in the SQL Search Text box to limit the rows returned to statements containing that text string.
Click on the "Refresh the List of Statements" button to retrieve the most resource-intensive SQL from the SGA. This returns all of the queries that match your criteria. The screen is divided into two parts:
    * The query results grid on the top half of the screen shows the query that was executed and the associated resources used (memory, disk reads, loads, etc.).
    * The bottom half of the screen displays the full SQL statement, execution statistics from the Oracle shared pool, and the Explain Plan for the query.
When necessary, you can pass a SQL statement into the SQL Editor from the SGA Trace window. Highlight the desired statement, then click on the "Load selected statement in a SQL Editor" button on the SGA Trace toolbar.
This toolbar also contains a button to "Flush the SGA." Your Oracle privileges dictate your logged-in user's ability to use this function.
    NOTE: SGA Trace Optimization requires access to a number of Oracle V$ objects.

So how do you utilize this information?
If you primary interest is simply finding highly shared SQL statements (i.e. those that get executed by many sessions), the main data grid has columns for “Users Opening” and “Users Executing”. You also can look at the “Sessions” tab contents for the statement to see the details of all those sessions accessing that shared SQL statement. However if your key interest is to tune those statements (once found), then the “SQL” tab offers toolbar icons to send the chosen SQL statement either to the Toad Editor or SQL Optimizer for manual or automatic tuning, respectively.
Remember, tuning those statements which get called the most either by a single session or collectively by many sessions will yield the greatest return on investment. If you can make a statement 2% faster and it gets called thousands of times per day (even if by different users), than the net effect will be highly positive.


Run Toad off a USB Flash Drive
Here are the steps:
1. Format the USB Flash Drive as an NTFS file system.
a. File explorer, right hand mouse, properties, hardware tab
b. Select the USB Flash Drive and press the properties button
c. Policies tab, choose Optimize for Performance and press OK
d. Format the USB Flash Drive – NTFS should now be available

2. Create TOAD_FLASH directory on your USB Flash Disk (at topmost level)

3. Download and then unzip the TOAD_FLASH.zip file onto your USB Flash Disk

4. Unzip the contained Oracle Instant Client installation file onto your USB Flash Disk

5. Install Toad for Oracle and copy the Toad home (install directory) to your flash drive
Example: xcopy /s /q "C:\Program Files\Quest Software\Toad 9.7" "X:\Toad 9.7\"

6. Run TOAD_FLASH_SETUP.bat file to install (and save pre-existing Toad setups)

7. Run TOAD_FLASH_RUN.bat file to launch Toad (must enter license first time)

8. Run TOAD_FLASH_RESTORE.bat file to restore PC back to prior Toad state

You can download the file at http://www.bertscalzo.com/Files/TOAD_FLASH.zip




Other Good Tools



Resources collected from
Get to know Toad 8.0
Get to know Toad 8.5
Get to know Toad 8.6
Get to know Toad 9
Get to know Toad 9.1
Get to know Toad 9.5
Get to know Toad 9.6
Get to know Toad 9.7



Download Location

 

Toad for Oracle 9.7.2.5 Parte1

http://rapidlibrary.com/download_file_i.php?qq=quest%20toad%209%207&file=7874744&desc=Toad+for+Oracle+9.7.2.5+www.softarchive.net.part1+.rar

Toad for Oracle 9.7.2.5 Parte2

http://rapidlibrary.com/download_file_i.php?qq=quest%20toad%209%207&file=7874745&desc=Toad+for+Oracle+9.7.2.5+www.softarchive.net.part2+.rar

Toad for Oracle 9.7.2.5 Parte3 

http://rapidlibrary.com/download_file_i.php?qq=quest%20toad%209%207&file=7874746&desc=Toad+for+Oracle+9.7.2.5+www.softarchive.net.part3+.rar

Toad for Oracle 9.7.2.5 Parte4

http://rapidlibrary.com/download_file_i.php?qq=quest%20toad%209%207&file=7874747&desc=Toad+for+Oracle+9.7.2.5+www.softarchive.net.part4+.rar


Toad 9.7.0.51.part1 .rar

http://rapidlibrary.com/download_file_i.php?qq=quest%20toad%209%207&file=8918324&desc=TOAD+9.7.0.51.part1+.rar

Toad 9.7.0.51.part2 .rar

http://rapidlibrary.com/download_file_i.php?qq=quest%20toad%209%207&file=8918325&desc=TOAD+9.7.0.51.part2+.rar