Here is a 2 second tweak that I recommend for all users of Oracle SQL Developer.
Open Tools – Preferences
- Database -
- Worksheet -
- ‘Grid in checkerboard or Zebra pattern’ – toggle ON
Grid option for alternating backgrounds
Now run a query in the worksheet or open a table in the browser
Grids in SQL Developer with the 'zebra option'
If you’re going to be staring at data for hours on end, give your eyes a break and mix it up a bit!
Twitter
RSS
GooglePlus
Facebook
Dec 05, 2011 @ 16:05:53
Only “checker board or zebra”…very uninspiring. If only the grid was totally customizable with many styles already available at your fingertips.
Dec 05, 2011 @ 16:09:20
90% of those styles are junk. But yeah, I’d like to see a few templates to choose from.
Dec 06, 2011 @ 15:21:21
How about being able to customize it any way you’d like. POWER TO THE PEOPLE!
Dec 06, 2011 @ 15:27:52
Grid enhancements are under consideration. Feel free to submit any particular ideas to the Exchange.
Dec 05, 2011 @ 18:05:29
Someone should suggest this to the 11.2 docs master books list…
Dec 05, 2011 @ 19:14:07
I can work on that, but what exactly do you think should be included, just this tip for SQLDev?
Dec 06, 2011 @ 04:59:09
For those who want to tweak around until SQLDev is broken (or want to sync their config between different machines) I found the proper config-file in
~/.sqldeveloper/system3.1.05.97/o.sqldeveloper.11.2.0.5.97/product-preferences.xml(the numbers might differ a little bit depending on the particular version).The Zebra is mentioned there in this section:
<hash n="DBConfig">
<value n="DEFAULTPATH" v=""/>
<hash n="EXTENSION"/>
<value n="GLOGIN" v="true"/>
<value n="INDENT_CACHE_NUMBER" v="2"/>
<value n="INDENT_CACHE_USE_TAB" v="false"/>
<list n="TPDRIVER"/>
<value n="ZEBRA_ROWS" v="true"/>
</hash>