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
use Perl Log In
djberg96 (2603)
djberg96
(email not shown publicly)
(email not shown publicly)
Thursday January 29, 2004
11:29 AM
TORa opera
After downloading the latest alpha of TORa (Tool for Oracle Developers) to my shock and horror (ok, I'm exaggerating) I discovered, along with many others, that the copyright now says "Quest Software, Inc".
Why did that cause shock and horror? Quest Software are the folks who make TOAD, a similar tool albeit Windows-only. In fact, Henrik's creation was Quest Software's only real competition. Coincidentally, I was aware that they were trying to recruit Henrik for some time. One of their software developers told me they were looking to hire him when I went to a TOAD user's group meeting in Minneapolis.
So now it seems Quest Software has finally recruited Henrik into their fold. This is a great move for Quest Software and probably a good move for Henrik. Unfortunately, it sucks for the rest of us. What will happen with TORa? Not sure, but a lively discussion has already started on the TORa home page (under discussion forums).
TORa opera
More |
Login
| Reply
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
--Larry Wall in stab.c from the perl source code
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
Alternatives? (Score:1)
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.
Re:Alternatives? (Score:1)
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
Re:Alternatives? (Score:2)
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. ;)
A few alternatives ... (Score:1)
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.
Re:A few alternatives ... (Score:2)
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?
Re:A few alternatives ... (Score:1)
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