Hello, you are not logged in.  Login or sign up
KNOWLEDGE >> Toad Knowledge >> Tips and Tricks
Toad on Twitter Follow Toad Search Toad World Search
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
 
Can I debug more than procedures and functions?
 
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
 
Customize Toad Tabs
 
Determine the correct number of RAC nodes to deploy for a given database
 
Did you know you can reference objects without leaving the Editor?
 
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
 
Format your T-SQL code
 
FTP with Toad?
 
Generating Schema Documentation
 
Global Search & Replace
 
Grants to fix Schema Browser when 07_DICTIONARY_ACCESSIBILITY enabled
 
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
 
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
 
Oracle Client Setup Problems?
 
Predictive Diagnostics
 
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 Scalability Test
 
Standardizing SQL formatting across the team
 
Test Your Database with Thousands of Users
 
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 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
 
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 relational data in one screen
 
Copyright 2010 by Quest Software  | Terms Of Use | Privacy Statement | Contact Us