Cool shortcut tricks for Toad's SQL Editor:

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.