I get this question every few months, and I got it again last week in Denver -
How can we setup auto-replace in SQL Developer? If I accidentally type ‘form’ I want it to come out as ‘from’ for example.
I’m not a huge fan of the IDE ‘automatically’ doing things with my editor text. What if I really wanted to type ‘form?’ BUT, we can get you there with the SQL Editor Code Templates.
So type, then hit Ctrl+Spacebar to activate.
Or watch the movie: