Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

OK, I've used TOAD in the past and it's pretty cool, but I don't feel like spending that kind of coin. What other Oracle 10g SQL editors are there?

Note: I don't need tuning tools, simply SQL query tools.

share|improve this question
    
I currently use SQL*Plus from Oracle. I'd like something that is able to give me previews of data in tables and views, and something that allows me to select code snippets and execute the queries from there. –  Shawn Anderson Jun 2 '09 at 19:06

7 Answers 7

up vote 7 down vote accepted

Oracle SQL Developer is free, Java based, graphical and made by Oracle. BUT it is made by Oracle, which should give you a hint about its overall usability (improving over versions, to be fair).

To be able to connect to Oracle 8i, you will need an old version of this tool (has to do with JDBC support, or rather lack of it). Try 1.2.1.

share|improve this answer
    
So true! I use SQL Developer, and it is so heavy and memory-hungry... I load it, use it and unload it as fast as possible. On my machine it usually takes up about 700MB of RAM :-o –  Yuval Jul 30 '09 at 14:07

I've always used TOra. Free software (GPL). I've used it on Linux, not sure if it runs on Windows.

They have screenshots if you're interested.

share|improve this answer
    
Looks like they do have Solaris, Windows, and Linux builds. sourceforge.net/project/… –  Shawn Anderson Jun 2 '09 at 16:16

Sqldeveloper from oracle Squirrel SQL, using de oracle jdbc driver.

share|improve this answer

Quote:

EMS SQL Manager for Oracle is a high performance database tool for Oracle Database server development and administration. SQL Manager for Oracle works with any Oracle versions from 8.1.7 to the newest one and supports the latest Oracle Database features and data types including compressed, OLAP, read-only and read-write tables; invisible indexes; compound triggers, triggers with FOLLOWS clause and others. It offers plenty of powerful Oracle tools such as PL/SQL Code Debugger, Backup/Restore Database wizards, Visual Database Designer to create Oracle database in few clicks, Visual Query Builder to write complex Oracle SQL queries, Database Statistics to monitor Oracle performance, Grant manager for effective Oracle security management and many more useful features for efficient Oracle administration. SQL Manager for Oracle has a state-of-the-art graphical user interface with a well-described wizard system, so clear in use that even a newbie will not be confused with it.

They also have a freeware version, with some limitations.

share|improve this answer

If your'e doing basic sysadmin queries, just use the standard Oracle SQL*Plus client that comes with a standard install. No additional cost.

If you need specific features, I'd mention them in your question.

share|improve this answer
    
Good point. I've added the comment to my question stating a little more about what I'm looking for. I currently use SQL*Plus. –  Shawn Anderson Jun 2 '09 at 19:06

Oracle Sql Developer has one really cool plugin from FourthElephant called Insider. It is a database monitor. It is a simple version that is free. (The advanced one you have to pay for.)

The tool that comes with Oracle, Enterprise Manager, is a good approach but doesn't give you the same type of visual cueing. Give it a try, its free.

SQL Plus is a dinosaur but faily solid as a script executer but not really good for PL/SQL.

One really odd alternative for you developers reading this are the oracle tools for visual studio. It has just about everything in it including debugging and is a free add-on for visual studio. If you are a developer that loves visual studio but is also trying to manage a test database this is a powerful tool.
One thing I really like about it is how it handle reference cursors. For some reason it is the best tool I have found for testing my reference cursors.

share|improve this answer

I agree Oracle SQLDEveloper is pretty good and a great price. We use it more than Toad now. Some early gotcha's ...

  1. Difference versions still available have different functionality (an earlier version we installed had a T-SQL -> PL/SQL tool, a later version didn't)... so a recent version that has what you need and stick with it.
  2. The default font will (or at least did) make a zero 0 and a capital letter O look the same, which we blew hours on once while trying to debug a query.
  3. We spent a while trying to set up a connection between our subversion repository and SQL developer, and never really got value from it.

Other than that, we've been happy with it, and it has a nice DDL exporting feature and Diff tool.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.