27 April 2007

Writing SQL Developer Reports

Much like hali, I have a preternatural dislike for Toad. There really is no valid reason for it, though, so I won't try to justify it. I just don't dig it. Equally unjustifiable is my preference for Oracle's own SQL Developer, especially now that it gives me a point-and-click interface for killing sessions. Well perhaps I can provide some justification in that Oracle SQL Developer comes packaged with ojdbc so I don't need to install anything else to run it other than the JDK. It's also completely free.

One thing that I had yet to do was add some of my own reports to the mix, and thanks to my previously-mentioned savior, Lewis Cunningham, I've begun that. Lewis has a nice PDF on how to write reports for SQL Developer, from basic table output to child (drill-down) reports to pie/bar/line charts.

No comments:

Post a Comment