ThatJeffSmith

Oracle SQL Developer 4 Quick Hit: Search and Replace

The new editor framework provides a more interactive and rich experience when replacing text. It’s a very simple improvement, but one that I think will make you feel ‘better.’ I know that’s a subjective measurement, but I’m sticking with it.

Our new Developer Days Lab with Oracle Database 12c and SQL Developer 4

Our new Developer Days Lab with Oracle Database 12c and SQL Developer 4

Each replacement is confirmed visually, in place, unless of course you opt for 'All.'

Each replacement is confirmed visually, in place, unless of course you opt for ‘All.’

And something I talked about earlier, double-clicking on a ‘word’ in the editor will auto-find and highlight all occurrences of that text. This is then automatically used as the basis of a search and replace exercise.

Double-click on the word, see the 'hits' and then do a one by one replacement if you'd like...

Double-click on the word, see the ‘hits’ and then do a one by one replacement if you’d like…

Regular Expression Validation

Thanks to Jack, I also just noticed that the search dialog auto-validates your RegEx search terms. The input text will remain ‘red’ until it’s a valid search term – this is of course after you toggle the ‘Regular Expressions’ checkbox on the search dialog.

As soon as I close that search term with the ']' the text will go from red to black.

As soon as I close that search term with the ‘]’ the text will go from red to black.

When Will This Fancy New Image Be Available for Download?

Soon. We’ll let you know as soon as it hits the presses. You can find the current version of it for download here.