Looking at endless spreadsheets or grids of data can make one’s brain a bit fuzzy.

SQL Developer makes it easy to spot the bad data you’re looking for.

Hit Ctrl+F in a grid.

Remember, you can do this in ANY grid in SQL Developer
Remember, you can do this in ANY grid in SQL Developer

Type your search term.

If you’re going to be looking for this data going forward, check the ‘Persist Highlight’ box.

So for example, if I’m getting ready to demo some Tips & Tricks and I want to call out the very nice local place I visited the night before, to curry favor with the German audience…

They had two kinds of beer, both were good.
They had two kinds of beer, both were good.
Thanks to Martin, Moritz, Jerome, Peter, and many others for making me feel quite at home!
Thanks to Martin, Moritz, Jerome, Peter, and many others for making me feel quite at home!

When you’re ready to forget about certain data, just open the Find/Highlight dialog again, and hit the delete button next to the persisted searches.

What it looks like

oracle sql developer animated gif find highlight data in a grid
you can search across all columns, or just one. You can have multiple searches in play – just use different colors so you know what you’re finding.
thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

4 Comments

  1. Howard Barker Reply

    If one has a table with >100K rows, is there a way to jump to the row(s) that has been found rather than having to scroll through the entire table

  2. Thanks for sharing, I never knew about this feature, and it’s quite useful for me!
    “Color” option doesn’t seem to work properly, though.

Reply To Arpod Cancel Reply