SQL Developer Quick Hit: Zebra Pattern Data Grids

thatjeffsmith SQL Developer 13 Comments

Tell Others About This Story:

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!

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Comments 13

  1. Hi,
    “Oracle SQL Developer” has been a nightmare for me. Is there any option which produces the result in “Grid” of the Query result?

    For some reason, I don’t see any output in the grid rather there is a message which states “Executing…” followed by the SQL statement.

    1. thatjeffsmith Post
      Author
  2. 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>

    1. JeffS Post
      Author
  3. Only “checker board or zebra”…very uninspiring. If only the grid was totally customizable with many styles already available at your fingertips.

    1. JeffS Post
      Author
        1. JeffS Post
          Author
          1. thatjeffsmith Post
            Author
          2. It’s been a year. Can we get an update on grid customization? I really like how customizable most of the UI is. It’s surprising that this hasn’t been provided yet.

          3. thatjeffsmith Post
            Author

            It’s about priorities. Cloud is first. Then everything else. It’s on my list. We’re starting to make progress on v4.2 stuff. I’ll see if I can sneak this in.

Leave a Reply

Your email address will not be published. Required fields are marked *