Useful shortcuts for vi editor

Wednesday, 6 December 2017

How to define "Code Templates" in SQL Developer?

e.g.
SQL DEVELOPER -> TOOLS -> PREFERENCES -> DATABASE -> SQL EDITOR CODE TEMPLATES -> Click "ADD TEMPLATE" button -> Input Id as "sl", Template as "select * from " -> OK

Usage:

Press "sl" and press "ctrl+space"

Output:

select * from