WELCOME, GUEST
Minimize
Tip Categories
Click the folders below to filter the tips by user type, product, or solution area.

 

Toad® Tips and Tricks

User Submitted Insights

Toad Tips and Tricks are a collection of suggestions, insights and how-tos from our in-house experts as well as Toad users from around the world.  

Do you have a tip you'd like to share?  Submit your tip.
All Tips
All of theToad tips at a glance ...

A tool to convert xml files into a format usable by Toad for Oracle
Add columns to Schema Browser (LHS)
Add to Database Health Check options
Analyzing DB2 table partitions
Applying and verifying naming conventions in data models
Are Toad passwords secure?
Automate grid - save as
Automating Data Extraction
Auto-open any window
Back up tables to Unix server automatically
Beware when Saving as Excel File
Calling Code Tester from Toad
Can I debug more than procedures and functions?
Change Latency values to Simulate Realistic Users
Change the look and feel of Toad for Data Analysts
Clone Cursor Option
Code Coverage Analysis in Code Tester 1.9
Code Road Map
Compare, merge, and convert models in Toad Data Modeler
Configure Toad Menus
Configure Toad to run and manage iTunes
Configuring the Schema Browser
Create a SQL insert script for a table with a self-referencing primary key
Creating Recovery Scripts
Customize Toad Tabs
Determine the correct number of RAC nodes to deploy for a given database
Did you delete or rename a column in one of your tables?
Did you know you can reference objects without leaving the Editor?
Do you need to find an object with specific comment?
Don't know SQL? Use the Query Builder
Educational resouces available from Toad Data Modeler
Execute different statement types from the Query Builder in Toad for Data Analysts
Execute Oracle Statements in External Applications
Executing your DB2 scripts remotely
Export selected data to Excel
Favorites in Schema Browser
Filtered Index feature in MS SQL Server 2008
Format your T-SQL code
FTP with Toad?
Generating Schema Documentation
Global Search & Replace
Grants to fix Schema Browser when 07_DICTIONARY_ACCESSIBILITY enabled
Graphically representing schema objects
How can I automatically connect and automatically open certain windows in Toad?
How can I build a test environment for individual code objects?
How can I edit data in the Editor?
How can I get Toad published on Citrix?
How can I shorten the list of Schemas in the Schema Browser and other windows?
How Does Toad do that in the Database?
How old is my object? When was it last altered?
How to bookmark your favorite SQL
How to control the number of rows in your grid
How to Edit Code Templates
How to tell which database a Toad window is connected
Improve SQL Performance with Virtual Indexing
IO Optimization
Learn to use the mouse
Let Toad manage your SQL*Plus scripts
Let toad show you the differences
Make sense of cryptic trace files
Naming your SQL
Only execute faster alternatives in the Batch Run of a tuning session
Optimizing SQL in a Data Warehouse / OLAP database
Oracle Client Setup Problems?
Predictive Diagnostics
Quickly browse and search the Oracle Alert Log
Quit Typing so much, use Code Snippets
Reducing steps to tune SQL
Replay an Oracle Trace file
Re-program Toad's keyboard shortcuts
Result set management
Running Cross-platform queries
Script to clean up your Toad for Oracle "temps" directory
Set up and run full regression tests on your code
Share object notes with colleagues
Speed up the time it takes for you to find the best SQL alternatives in SQL Optimizer for Oracle
Spotlight Memory Management Tuning
SQL Editor Shortcuts
SQL Monitor and Spool SQL to Screen
SQL Plan Management
SQL Scalability Test
Standardizing SQL formatting across the team
Switch display modes
Test Your Database with Thousands of Users
Testing SQL with Virtual Indexes
TNSNAMES Editor
Toad can generate data with Table DDL
Toad can help you tune your OS Kernel
Toad Editor Files
Toad for MySQL Export Wizard
Toad for Oracle - Complete Tips and Tricks Presentation
Toad for SQL Server Collaboration
Toad Report Manager (Toad 9.0 and above)
Toad’s Make/Strip Code
Toad’s Script Debugger (8.0 and higher)
Toad's SQL Editor Explain Plan
Treat an Excel spreadsheet like a table
Use Remote Agents to Execute More Stressful Tests
Use Spotlight to send e-mail alerts while it is running
Using Query Builder when creating Views
Validate your PL/SQL code for scalability
Variable Randomization using Scripts
View, undo, and redo database changes using Toad’s Transaction Log Reader
View/Edit Object and Column level comments
Viewing DB2 Applications
Viewing Excel data sources
Viewing Oracle Trace Files
Viewing relational data in one screen