# Code Templates **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [April 13, 2011, 4:58am UTC](https://forums.toadworld.com/t/code-templates/10382 "2011-04-13T04:58:42Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [April 13, 2011, 4:58am UTC](https://forums.toadworld.com/t/code-templates/10382/1 "2011-04-13T04:58:42Z")
SEE ATTACHMENT acip.vcf (298 Bytes) ![image001.jpeg](https://global.discourse-cdn.com/quest/original/2X/e/e116b4c84f27bd77fd3220f8a4f05f089f0a582f.jpeg) ![image001.jpeg](https://global.discourse-cdn.com/quest/original/2X/e/e116b4c84f27bd77fd3220f8a4f05f089f0a582f.jpeg) ![image003.gif](https://global.discourse-cdn.com/quest/original/2X/2/23dc0bcabc260e2cfa371cfd7e9c6ed59a4d65e8.gif) ![image004.jpeg](https://global.discourse-cdn.com/quest/original/2X/b/bdb01c001c863b869933c5611edbacfe65be43d6.jpeg) ![image005.gif](https://global.discourse-cdn.com/quest/original/2X/2/21a236c416ff28274d8bfca18fce07b8047e17a8.gif) ![moz-screenshot-11.png](https://global.discourse-cdn.com/quest/original/2X/a/a51fee480f6be87e99e8db341b0a492c58939ad5.png) ![moz-screenshot-12.png](https://global.discourse-cdn.com/quest/original/2X/3/3d7d152113a9eb5f701177bef9c4c0b99d577a34.png) [acip.vcf](https://forums.toadworld.com/uploads/default/original/2X/7/7d6e70093e1105a08609b00ed961cb29691a27af.vcf) (328 Bytes) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [April 13, 2011, 6:08am UTC](https://forums.toadworld.com/t/code-templates/10382/2 "2011-04-13T06:08:22Z")
To answer #2, according to the TOAD Help File: Advanced Templates An advanced template allows you to use pipe characters literally in the code template. A simple (not advanced) template uses the pipe character to determine caret placement when the template has been inserted into the Editor. An advanced template uses to determine where the caret will go. Advanced templates also support inserting data from clipboard. Clipboard data is inserted where displays. To use the advanced template ``` In the View | Toad Options | Editor - Behavior page, click Code Templates. In the template grid, select the advanced checkbox beside the template you want to use in the advanced mode. ``` ![image004.jpeg](https://global.discourse-cdn.com/quest/original/2X/e/eb1cfa5c5c3c8794a0116ded47526f65179ebf62.jpeg) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [April 13, 2011, 6:08am UTC](https://forums.toadworld.com/t/code-templates/10382/3 "2011-04-13T06:08:22Z")
To answer #2, according to the TOAD Help File: Advanced Templates An advanced template allows you to use pipe characters literally in the code template. A simple (not advanced) template uses the pipe character to determine caret placement when the template has been inserted into the Editor. An advanced template uses to determine where the caret will go. Advanced templates also support inserting data from clipboard. Clipboard data is inserted where displays. To use the advanced template ``` In the View | Toad Options | Editor - Behavior page, click Code Templates. In the template grid, select the advanced checkbox beside the template you want to use in the advanced mode. ``` ![image005.gif](https://global.discourse-cdn.com/quest/original/2X/2/21a236c416ff28274d8bfca18fce07b8047e17a8.gif) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [April 13, 2011, 6:08am UTC](https://forums.toadworld.com/t/code-templates/10382/4 "2011-04-13T06:08:22Z")
To answer #2, according to the TOAD Help File: Advanced Templates An advanced template allows you to use pipe characters literally in the code template. A simple (not advanced) template uses the pipe character to determine caret placement when the template has been inserted into the Editor. An advanced template uses to determine where the caret will go. Advanced templates also support inserting data from clipboard. Clipboard data is inserted where displays. To use the advanced template ``` In the View | Toad Options | Editor - Behavior page, click Code Templates. In the template grid, select the advanced checkbox beside the template you want to use in the advanced mode. ``` ![image002.png](https://global.discourse-cdn.com/quest/original/2X/d/dc7523d3b3d9ec0d7a6317f0237d21cd60330ab8.png) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [April 13, 2011, 6:08am UTC](https://forums.toadworld.com/t/code-templates/10382/5 "2011-04-13T06:08:22Z")
To answer #2, according to the TOAD Help File: Advanced Templates An advanced template allows you to use pipe characters literally in the code template. A simple (not advanced) template uses the pipe character to determine caret placement when the template has been inserted into the Editor. An advanced template uses to determine where the caret will go. Advanced templates also support inserting data from clipboard. Clipboard data is inserted where displays. To use the advanced template ``` In the View | Toad Options | Editor - Behavior page, click Code Templates. In the template grid, select the advanced checkbox beside the template you want to use in the advanced mode. ``` ![image002.jpeg](https://global.discourse-cdn.com/quest/original/2X/7/7e42a01395e08f35bf636eda47a232dd1c0a6bb3.jpeg) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [April 13, 2011, 6:08am UTC](https://forums.toadworld.com/t/code-templates/10382/6 "2011-04-13T06:08:22Z")
To answer #2, according to the TOAD Help File: Advanced Templates An advanced template allows you to use pipe characters literally in the code template. A simple (not advanced) template uses the pipe character to determine caret placement when the template has been inserted into the Editor. An advanced template uses to determine where the caret will go. Advanced templates also support inserting data from clipboard. Clipboard data is inserted where displays. To use the advanced template ``` In the View | Toad Options | Editor - Behavior page, click Code Templates. In the template grid, select the advanced checkbox beside the template you want to use in the advanced mode. ``` ![image001.jpeg](https://global.discourse-cdn.com/quest/original/2X/3/3e6e11da5d2965936044d8a537f5ca057ef32e9e.jpeg) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [April 13, 2011, 6:08am UTC](https://forums.toadworld.com/t/code-templates/10382/7 "2011-04-13T06:08:22Z")
To answer #2, according to the TOAD Help File: Advanced Templates An advanced template allows you to use pipe characters literally in the code template. A simple (not advanced) template uses the pipe character to determine caret placement when the template has been inserted into the Editor. An advanced template uses to determine where the caret will go. Advanced templates also support inserting data from clipboard. Clipboard data is inserted where displays. To use the advanced template ``` In the View | Toad Options | Editor - Behavior page, click Code Templates. In the template grid, select the advanced checkbox beside the template you want to use in the advanced mode. ``` ![moz-screenshot-11.png](https://global.discourse-cdn.com/quest/original/2X/a/a51fee480f6be87e99e8db341b0a492c58939ad5.png) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [April 13, 2011, 6:08am UTC](https://forums.toadworld.com/t/code-templates/10382/8 "2011-04-13T06:08:22Z")
To answer #2, according to the TOAD Help File: Advanced Templates An advanced template allows you to use pipe characters literally in the code template. A simple (not advanced) template uses the pipe character to determine caret placement when the template has been inserted into the Editor. An advanced template uses to determine where the caret will go. Advanced templates also support inserting data from clipboard. Clipboard data is inserted where displays. To use the advanced template ``` In the View | Toad Options | Editor - Behavior page, click Code Templates. In the template grid, select the advanced checkbox beside the template you want to use in the advanced mode. ``` ![image003.gif](https://global.discourse-cdn.com/quest/original/2X/2/23dc0bcabc260e2cfa371cfd7e9c6ed59a4d65e8.gif) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [April 13, 2011, 7:08am UTC](https://forums.toadworld.com/t/code-templates/10382/9 "2011-04-13T07:08:14Z")
For #1: Options\>Editor\>Behavior\>Key Mapping ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [April 13, 2011, 7:14am UTC](https://forums.toadworld.com/t/code-templates/10382/10 "2011-04-13T07:14:26Z")
SEE ATTACHMENT ![image002.jpeg](https://global.discourse-cdn.com/quest/original/2X/7/7e42a01395e08f35bf636eda47a232dd1c0a6bb3.jpeg) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [April 13, 2011, 7:14am UTC](https://forums.toadworld.com/t/code-templates/10382/11 "2011-04-13T07:14:26Z")
SEE ATTACHMENT ![image003.gif](https://global.discourse-cdn.com/quest/original/2X/2/23dc0bcabc260e2cfa371cfd7e9c6ed59a4d65e8.gif) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [April 13, 2011, 7:14am UTC](https://forums.toadworld.com/t/code-templates/10382/12 "2011-04-13T07:14:26Z")
SEE ATTACHMENT [acip.vcf](https://global.discourse-cdn.com/quest/original/2X/7/7d6e70093e1105a08609b00ed961cb29691a27af.vcf) (328 Bytes) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [April 13, 2011, 7:14am UTC](https://forums.toadworld.com/t/code-templates/10382/13 "2011-04-13T07:14:26Z")
SEE ATTACHMENT [att1.dat](https://global.discourse-cdn.com/quest/original/2X/4/47a71b5fd457cf0aa41d2110a49a087e5902b9d5.dat) (1.79 KB) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [April 13, 2011, 7:14am UTC](https://forums.toadworld.com/t/code-templates/10382/14 "2011-04-13T07:14:26Z")
SEE ATTACHMENT ![image001.jpeg](https://global.discourse-cdn.com/quest/original/2X/3/3e6e11da5d2965936044d8a537f5ca057ef32e9e.jpeg) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [April 13, 2011, 7:14am UTC](https://forums.toadworld.com/t/code-templates/10382/15 "2011-04-13T07:14:26Z")
SEE ATTACHMENT ![image005.gif](https://global.discourse-cdn.com/quest/original/2X/2/21a236c416ff28274d8bfca18fce07b8047e17a8.gif) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [April 13, 2011, 7:14am UTC](https://forums.toadworld.com/t/code-templates/10382/16 "2011-04-13T07:14:26Z")
SEE ATTACHMENT [att1.dat](https://global.discourse-cdn.com/quest/original/2X/6/6f92c6a780ea291ee0a650480b05c386c5de0931.dat) (1.98 KB) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [April 13, 2011, 7:14am UTC](https://forums.toadworld.com/t/code-templates/10382/17 "2011-04-13T07:14:26Z")
SEE ATTACHMENT ![image003.gif](https://global.discourse-cdn.com/quest/original/2X/2/23dc0bcabc260e2cfa371cfd7e9c6ed59a4d65e8.gif) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [April 13, 2011, 7:14am UTC](https://forums.toadworld.com/t/code-templates/10382/18 "2011-04-13T07:14:26Z")
SEE ATTACHMENT [att1.dat](https://global.discourse-cdn.com/quest/original/2X/f/fd5e807cd1665925c897ee77a02ae3406f873609.dat) (1.49 KB) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [April 13, 2011, 7:14am UTC](https://forums.toadworld.com/t/code-templates/10382/19 "2011-04-13T07:14:26Z")
SEE ATTACHMENT [att1.dat](https://global.discourse-cdn.com/quest/original/2X/7/7def65ba746fcc0b6214a7805d1596359a6b4917.dat) (24.9 KB) ---
**Author:** ![acip](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@acip](https://forums.toadworld.com/u/acip)\ **Post date:** [April 13, 2011, 7:14am UTC](https://forums.toadworld.com/t/code-templates/10382/20 "2011-04-13T07:14:26Z")
SEE ATTACHMENT ![image005.gif](https://global.discourse-cdn.com/quest/original/2X/2/21a236c416ff28274d8bfca18fce07b8047e17a8.gif) [Next page](https://forums.toadworld.com/t/code-templates/10382.md?page=2)