Toad for Oracle Unleashed

Auto Replace

Auto replace is like a spell checker; in fact, this feature actually does correct some spelling errors as well as correct obsolete code. This feature is activated via the space bar. It takes the last item entered since the prior space bar and compares it to a list. If the text is found in the list, the auto replace item is automatically substituted.

This feature is nice for long column names perhaps (although Toad Insights is a better mechanism for this), but it is used more for commonly entered items such as sf for SELECT * FROM or pl for DBMS_OUTPUT.PUTLINE( );.

Chapter 6 discusses a way to use existing code templates and how to add your own.

In an editor window, type in “teh” and when you press the space bar, it will be corrected ...