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

 
WELCOME, GUEST
 
 

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.  

 FEATURED DOWNLOADs:   
Complete Toad for Oracle Tips and Trick Presentation (Toad 10.0) 
by Toad expert, Jeff Smith.
 
  Complete Toad for Oracle Tips and Trick Presentation (Toad 10.5) 
by Toad expert, Jeff Smith.
 

Do you have a tip you'd like to share?  Submit your tip.

Previous   BackToCategory   Next  50 of 102
How to bookmark your favorite SQL

 

 

 

Ever need a quick way of retrieving your favorite sql statements without browsing for them?

When you are in the editor and you have your sql statement open, go up to the Edit Menu and select "Add to Named SQLs". This will prompt you to give your sql statement a name. If you want to add a statement to your favorites and you ran it a while ago and no longer have it open, just press "F8" to open your SQL Recall window and find it under the History tab. Once you locate the sql statement, right click on it and add it to your Named SQLs.

In the future now, when you open an editor use the hotkeys "Cntrl+N" and it will open a list of your Named SQLs you have saved. Click the one you want and it opens immediately into your editor.

This way you can quickly call sql statements you use most often without browsing for them or opening up a sql file that may contain them.


Previous   BackToCategory   Next  50 of 102