Automatically Replace SQL

Use Auto-Replace in the Editor

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

Related Topics

About Editing SQL