pink cylinders

More than Four

...there's an axis for that.

A light-weight SQL editor plugin for Eclipse IDE

Eclipse is not my primary IDE, but I do find it very useful for editing ANT project definitions, especially the outline view.

I use generic projects in Eclipse Juno 4.2 to manage collections of DDL scripts, but I did miss SQL syntax highlighting. Well, no more! 

I found this plugin on the Internet: http://blog.debertshaeuser.com/index.php?page=eclipse-sql-editor.

Just download the jar and put it in the eclipse/plugins folder, then re-start Eclipse. It works great:

Long columns wrapping in the SQL Result Grid

Have you ever experienced a moment when you find that an application you've used for years has a feature that, if only you'd known about it, would have saved you time over and over again? It's a mixed feeling... one one hand, it's "Yay, this software is awesome!" and the other it's "Doh! I'm an idiot!". 

Well, PL/SQL Developer just handed me another of those moments. 

In the result grid of the SQL Query window, you can resize any row by grabbing the separator line in the margin and pulling down. I think I knew that... but what didn't realize is that any column with a long string will then wrap into the extra space, like this:

I think that is pretty cool. And it's been in the product since at least version 8 (which is what I've used for the last few years).