Navicat Oracle features an intuitive GUI and offers powerful visual tools such as Query Editor with syntax highlight capability, SQL Preview, SQL Console, TEXT, Hex and BLOB viewer/editor, SSH Tunnel and more, to increase your productivity.
Also, Navicat provides a number of tools allowing to perform all the necessary database operations such as creating, editing, and duplicating database objects. It also offers a well-described wizard system that simplifies your database development tasks and a full featured graphical manager for setting the users and access privileges.
Navicat for Oracle can connect to any Oracle Database version 9i and later and runs on Windows and Mac OSX with remote connection capability. Navicat is also available for MySQL and PostgreSQL.
Easy installation and intuitive interface make it an irreplaceable tool for Oracle on the web or your local desktop. Download a free Navicat Oracle manager at: http://oracle.navicat.com/download.html.
Jcoder is an efficient and easy to use Java IDE for Windows. Jcoder features an intuitive interface and provides a wide range of features: customizable user interface, project management, class/ package viewer, code-completion, debugger interface, editor with syntax highlighting, useful wizards and more. See details at: http://www.jcoder.com.

I just tried out Navicat Oracle database tool and have some comments.
pros:
- very intuitive user interface
- light and responsive
- free of charge
- the website said that its full version will include lots of more features such as Import/Export, Tasks scheduling, Visual Database Designer and probably PL/SQL Debugger
cons:
- doesn't support Linux
- doesn't support Oracle 8i
Overall, it's the best Oracle GUI tool I ever tried. I strongly suggest it to everyone who want to work more efficient.

I've been using Aqua Data Studio with Oracle for a while. It's the nicest GUI environment for database queries I've used, much more pleasant to me than SQL-Developer or TOAD.
It's written in Java, so can run on any platform. And it includes specific support for Oracle 8i upwards, SQL-Server 7 upwards, various Sybase flavors, DB2, Informix, MySQL and PostgreSQL, as well as Generic JDBC and ODBC.
One of the things I really like about ADS is the consistent and reliable keyboard and focus behavior. I'm too lazy to navigate around applications using the mouse all the time, and ADS is surprisingly good with the keyboard.
Another example of a nice feature that I really like is its ability to retrieve old queries. You can search one date ranges and query text, and pretty easily track down prior queries. I've used this several times to recover queries I'd written weeks previously. And I average a couple dozen ad-hoc queries per day.
I'm using Linux, so I guess I can't try Navicat. :-(
John Hurst
Wellington, New Zealand

I'm a professional database developer and have lots of tables to manage in my Oracle database. What I'm looking for is a software which can speed up my daily tasks. I tried Aqua and realized it's using JDBC to connect to Oracle or other DBMS. Its performance is slow compared to other database tools that I've used. And I believe this is due to the fact that it's written in Java.
Furthermore, I spend 90% of my time on a Mac and Aqua is not working as a native Mac OS X application due to its Java based nature.
Last but not least, there are many good and FREE Oracle database tools why I've to pay $399 for a single license that can't speed up my work?

I'm not a Mac guy. But I have a colleague who is a long-time Mac guy and he uses several Java/Swing apps regularly: IDEA, oXygen XML, SmartSVN. I was under the impression that they worked pretty well on the Mac.
Personally I used SQL-Developer for a couple of years and still recommend it to casual SQL users because it's free. But it's also a little quirky. For myself I found Aqua sufficiently more pleasant and more productive to be worth the money.
I am a bit perverse I guess: I do buy tools. (I also spend a lot of my time in SQL-Plus, which could also be considered perverse.)
John Hurst
Wellington, New Zealand

Navicat provides a number of tools allowing to perform all the necessary database operations such as creating, editing, and duplicating database objects. It also offers a well-described wizard system that simplifies your database development tasks and a full featured graphical manager for setting the users and access privileges.

Navicat for Oracle can connect to any Oracle Database version 9i and later and runs on Windows and Mac OSX with remote connection capability. Navicat is also available for MySQL and PostgreSQL.

Easy installation and intuitive interface make it an irreplaceable tool for Oracle on the web or your local desktop.

How this tool stack against the Acqau data studio (http://www.aquafold.com/). I can already see that Navicat doesn't support version 8i of Oracle which is still supported by Acqua data studio. Besides this I never found the price of standard and enterprise editions of Navicat any where on their website.

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations technology projects - with its network of technology-specific websites, events and online magazines.