Slash Boxes
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.
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 []), 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 [] 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 remote databases, so it has required SSH in and then a prompt at the remote machine, as you guessed.

        Pity about TORA, though. I've used TOAD and SQL navigator (both made by Quest) and they're increasingly looking like the same product, albeit with different names :( Some choice in the market would have helped.