SQL Developer is my current editor of choice. I'd like to know if there are any other free editors that are any good. Mostly I just need to run the occasional query and explore my schema so it doesn't have to be too sophisticated. SQL Developer 1.5 feels a little clunky and crashes more than I'm comfortable with. Hopefully v2 will be better once that's released.
Answer by StewStryker ·
Right, if it ain't broke, why fix it? For free, SQL Developer does pretty well.
Another option is the free license for Quest's Toad. Here's some info from their website:
"This is the FREEWARE edition of Toad for Oracle. The Freeware edition has certain limitations, and is not intended to be used as a TRIAL for the Commercial edition of Toad for Oracle. The Toad for Oracle Freeware version may be used for a maximum of five (5) Seats within Customer's organization and expires each sixty (60) days after the date of its initial download ("Freeware Term"). Upon expiration of the Freeware Term, the same 5 Seats may be downloaded again by the same users for the Freeware Term. For more than five (5) users within an organization, Customer will need to purchase licenses of Commercial Toad for Oracle. This license does not entitle Customer to receive hard-copy documentation, technical support, telephone assistance, or enhancements or updates to the Freeware from Quest. The terms "Seat" and "Freeware" shall have the same meaning as those set forth in the Product Guide located at www.quest.com/productguide. "
Finally, as I said elsewhere, I'm a fan of PL/SQL Developer from Allround Automations. I think it's much stronger and it's not that expensive considering how well it works. It was $145 last I knew. I like the way it works much better than either Oracle's SQL Developer, Quest's Toad or Quest's SQL Navigator, but that's probably because I work as an Oracle programmer, not a DBA.
Good luck and thanks for the vote-up if you think this answer is helpful. I'm trying to build my street cred here.
Answer by Hector Minaya ·
I think SQL Developer is your best choice, as far as free tools. Personally I use PL/SQL developer, but it's a paid tool.
It's the best tool for programming in Oracle...
Edit: I'm stating this from a programmer's view, not an Oracle DBA.
Answer by JordanS ·