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. ...

Get Toad for Oracle Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.