SQL Developer: Tools -> Preferences -> Code Editor -> Code Templates

Apparently, between version 19 and 21, the menu item Code Templates has moved from Tools -> Preferences -> Database -> SQL Editor Code Templates.

A code template is textual abbrevation for a predefined text snippet (the template). This abreviation is epxanded with ctrl+space.

The predefined code templates are stored in the file CodeTemplate.xml under the user information directory. (In Windows the user information directory is %appdata%\SQL Developer).

The German name for this menu is Extras -> Datenbank -> Codevorlagen für SQL-Editor.

Code templates not triggered

Sometimes, code templates are not triggered.

I was unable to determine exactly when that's the case, but it seems that the current worksheet needs to be at least connected to a database.

Sometimes, the template was only triggered when I entered it directly at a lines beginning, i.e. no spaces before the abbreviation.

It also seemed that semicolons on the worksheet had an influence on the abbreviation being triggered.

At times, ctrl+space would open a pop-up, but then I'd still have to muse the cursor keys on the keyboard to select the text.