Home > Articles > Data > Oracle

TOAD SQL Editor

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Code Completion Templates

Code completion templates are boilerplate syntax where you type in the correct names, and so on, but the correct syntax with options is supplied.

Code completion templates work a lot like aliases except that they provide the entire syntax rather than just a word or object name. Figures 3.30 and 3.31 illustrate how this works. Instead of hitting the '.' to signal the replacement, you press Ctrl+Spacebar to signal the replacement.

Figure 3.30Figure 3.30Code completion template key sequence.


Figure 3.31Figure 3.31Code completion template in action.


Ctrl+Spacebar signals code template.

Like the autoreplacement feature, additional code completion templates are easily added by using the Edit, Editor Options, Code Templates screen, as shown in Figure 3.32.

Figure 3.32Figure 3.32Adding code completion templates.


You can also edit the PLSQL.DCI file in <TOAD Home Directory>\temps and add additional templates with a text editor. See Figure 3.33 for the layout example.

Figure 3.33Figure 3.33Code completion template file layout.


Supported languages for code completion are HTML (<TOAD home>\temps\HTMLSUB.DCI), INI (<TOAD home>\temps\INISUB.DCI), JAVA (<TOAD home>\temps\JAVASUB.DCI), and TEXT (<TOAD home>\temps\TEXTSUB.DCI).

NOTE

Be sure TOAD is NOT running when you are editing any of these files in the TEMPS directory. TOAD rewrites these files when closing, and any changes made to the files with TOAD running will be lost.

  • + Share This
  • 🔖 Save To Your Account