Search notes:

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

See also

Tools -> Preferences -> Shortcut Keys and View -> Snippets
Tools -> Preferences -> Code Editor -> Completion Insight
With the PowerShell module SQL-Developer, its possible to add a code template with add-SQLDeveloperCodeTemplate $abbr $expansion.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758203817, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/Software/Oracle-SQL-Developer/GUI/menu/Tools/Preferences/Code-Editor/Code-Templates/index(68): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78