Update: we added the auto-replace option in a later version of SQL Developer, so if you don’t see it in your version, UPGRADE.
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. So this is not the default behavior, but you can set it up.
We can get you there with the SQL Editor Code Templates.
So type, then hit Ctrl+Spacebar to activate.
Or, check ‘Autoreplace’ in the dialog, and as soon as you hit the spacebar or carriage return, presto-bingo.
Or watch the movie: