Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • So, what other great Oracle client tools are there out there?

    Not that I don't want to use TOAD or TORa, but I have yet to find any truly great tool for simply running SQL queries and getting decent and useful error messages. I find that extremely a) annoying and b) surprising.
    • One of my favorites is SQLTools [sqltools.net]. It can run SQL queries, bring up table defs, shows results in a separate grid, lets you export the results as text, CSV or straight to Excel, lets you browse and pull source for different schema objects, it slices, dices, makes hundreds of julienne fries. :) Mind you, I'm still looking for the ultimate Oracle utility, but SQLTools comes pretty close.

      --
      Buck
      • Interesting, but it isn't immediately clear to me that this works on platforms other than Windows. That's one of the main reasons I liked TORa - I could run it on my Solaris box.

        In any case, I doubt TORa is going away any time soon. It will probably be forked in the worst case scenario. Frankly, I'm surprised no one has written something in Java. Maybe I should check for an Eclipse plugin. ;)

  • I'm a heretic for even suggesting it, but I have found the SQL worksheet (one of Oracle's Java toys) to be decent.. I've used it on Win32, Linux and Solaris.. Even Enterprise Manager might give you some joy.

    I've also tried out Orac ( link [tux.org]), which isn't too bad. I do remember seeing a few basic Java based Oracle frontend tools (a quick google didn't yield anything, tho.. sorry)


    Real men use the SQL prompt.. who needs anything else?

    I couldn't resist that one.. sorry again *grin*. But it's true, honestly.

    • Real men use the SQL prompt.. who needs anything else?

      Blech. Like I really wanna look at an explain plan on the command line. Besides, there are way too many options to remember for the command line. The ability to edit data directly through the schema browser rather than having to construct sql statements is *sooo* nice. Plus, tools like TOAD come with extra tools, like a SQL optimizer, and others I'm probably not aware of because I'm not a DBA.

      Why would you be displaying a tool like TORA remotely?

      • Well, for explain plan in particular, I use a script like this one [demon.co.uk] which pretty prints and indents properly. Yep, it's a nitpick. Not arguing with the fact that GUI tools (like Toad) are much easier to use and nicer to look at.

        I like the sql prompt for much the same reasons as I prefer the command line, really.. and like vi, the SQL prompt is the only thing which you're guaranteed will be there when you login to a strange machine that you've never seen before :) Some of my work in the past has been to rem