You can instruct Toad to automatically replace misspelled words or to replace a placeholder word with a phrase or statement when entering SQL in the Editor. This is done by setting up Auto-replace templates through the Options dialog.
Go to Tools | Options | Editor | Auto-replace to create Auto-replace templates. Auto-Replace Options
Examples of what you can do with Auto-replace templates
If you specify a substitution pair of teh = the , when you type teh in the Editor, Toad automatically changes it to the after you press SPACE.
If you specify a substitution pair of NDF = NO_DATA_FOUND, when you type NDF in the Editor, Toad automatically replaces it with NO_DATA_FOUND after you press SPACE.
Tip: Toad provides built-in functions (Toad Script) that can be used in SQL scripts in the Editor. Some can used with variables to specify keywords or identifiers in statements. About Toad Script
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center