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.
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…
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.
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
yes, use SQL
select * from table where rownum > 99999
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.
Yeah, I noticed that too! Bugged and will hopefully be fixed for 4.1