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.
  • 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? It's a client side tool. It should be on your local machine, unless you mean that you have to login to a remote machine *first* and then work from there.

      • 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