Toad for Oracle Unleashed

Using Code Templates

Toad comes with many useful code templates. These templates range from nested IF-THEN-ELSE logic to cursor loop examples. These templates also can contain substitution variables.

Ctrl+spacebar opens the templates pop-up menu (see Figure 6.9). Dozens of templates are available; take a few minutes to explore the code that comes with Toad. Figure 6.10 shows the template and any substitution variables. The Cursor Loop template has one substitution variable—notice that EMP will be substituted into the code when you click the OK button. Figure 6.11 shows the code after substitution. The vertical bar in the template code indicates where the cursor will be placed as well. These templates can contain more than one substitution variable. ...