Are you sure it does not work? Please be more specific in your comments. Do you mean ...
1. You cannot find the preference that displays seeded code template definitions / allows you to define additional code templates.
2. A defined code template does not display properly in the Completion Insight list of an editor (worksheet or PL/SQL code editor).
3. A code template defined in an earlier SQL Developer release does not migrate correctly to the 4.0 release.
Using Tools -> Preferences -> Database -> SQL Editor Code Templates, I can see the seeded templates and add new templates. In the worksheet, I can type either the Id or Template value and see the template appear in the Completion Insight list. Have you verified that Tools -> Preferences -> Code Editor -> Completion Insight is enabled for the editor you are using?
SQL Developer Team
Thanks for the clarification. I see now how an Other / Code Template shortcut key invoked after typing an Id of a Code Template works in SQL Developer 3.0.
I recently noticed someone logged a bug regarding missing shortcuts, but I have no idea if it specifically mentions the Other / Code Template case. Perhaps the component owner will see this thread and comment further.
I must say, however, that the Completion Insight feature in conjunction with typing the Code Template's Id or value provides the same functionality (except, perhaps, for appending the template after the Id rather than replacing it). I see no real impediment here to discourage you from upgrading to 4.0. And, after all, this is currently an Early Adopter release, so this regression may get fixed prior to a production 4.0 release.
Thanks for reply.
I know the Completion Insight works, but it's a little bit uncomfortable for me: type some characters, wait for CI and then move with arrows to the required template. It's much more easier just to type one character (my code template id) and instantly use the Code Template shortcut...
Yes, me too I agree it's uncomfortable to work only with "Completion Insight" (not to mention that I do not work with him because he is uncomfortable for usage). I worked only with Code Tamplate's short cut key(s), and in the 4-th version it disappeared.
I do hope that in the 4-th production release, it appears again (please)!
There is an workaround :
1) Export the shortcuts to an xml file
2) Edit it to add an entry for the code template shortcut
<hash> <value n="action" v="Worksheet.code_template"/> <value n="global" v="false"/> <list n="key-strokes"> <hash> <value n="key-1" v="alt "/> </hash> </list> </hash>
This entry should be inserted in the hash corresponding to oracle/dbtools/worksheet/editor/accelerators.xml
3) reload the file an now you should use Alt+T for code template.
Hope this would help.