Igor Kromin |   Consultant. Coder. Blogger. Tinkerer. Gamer.

NOTE: This article is 3 years or older so its information may no longer be relevant. Read on at your own discretion! Comments for this article have automatically been locked, refer to the FAQ for more details.
So I've been using SQLDeveloper like mad lately and have been finding some really neat features that it provides. One of the great time savers is its ability to create persistent highlights that you can use to instantly see the patterns in data. Great for debugging that ETL!

This is what I mean by the highlights, in this case I was looking at a table of test results and wanted to see which ones were failed, without a highlight I had to strain my eyes and look at each word, with the highlight, it's like magic, the failed tests just pop out instantly!
sqldevhighlight1.png


So how do you turn this amazing feature on?



When looking at results/data simply right click and select 'Find/Highlight...'
sqldevhighlight2.png


This brings up a dialogue box, in my case I typed in 'fail' in the, ticked 'Whole Word' and 'Persist Highlight' and chose a red colour to display the cell with.
sqldevhighlight3.png


This will save the highlight for good, it can be removed later by clicking the X button in the same dialogue box next to the previously persisted highlight.

There is a bit of a bug I found with the highlight colour selector on OS X however, it seems that when you click to select a colour, the entire dialogue box disappears. The way to get around this is to click the down arrow on the colour selector and use arrow keys to select the colour instead.

-i

Skip down to comments...
A quick disclaimer...

Although I put in a great effort into researching all the topics I cover, mistakes can happen. If you spot something out of place, please do let me know.

All content and opinions expressed on this Blog are my own and do not represent the opinions of my employer (Oracle). Use of any information contained in this blog post/article is subject to this disclaimer.
 
comments powered by Disqus
Other posts you may like...