Menu
Toad for Oracle Freeware users will be especially happy to access all Toad for Oracle Base features: its fully featured editor, PL/SQL debugging, profiling, PL/SQL unit testing, task automation, schema/data compare and full integration with version control — plus tech support.
Toad has a master detail record viewer, SQL Developer does not. Both tools have a query builder, but I feel Toad's is more robust and you can convert the SQL to ANSI joins or regular syntax and appears to do quite a bit more with where clauses, sub queries, and other parts of SQL.
Oracle Database Tools Service. Oracle Database Tools Service is a managed offering in Oracle Cloud Infrastructure (OCI) that enables you to create connections to any Oracle Database in OCI that can be reused by multiple users, resources, and services.
Toad Mac Edition exists no more. Now is Toad Edge, but only works with MySQL.
Oracle's SQL Developer.
PL/SQL Developer from http://www.allroundautomations.nl/. Presented between a choice between Toad and PL/SQL developer, about half the developers prefer PL/SQL developer. I have to admit the code completion in PL/SQL developer is much better, but I still prefer Toad for the DBMS management functionality.
TOra is an another good option. I used the pre GPL version for years. It's a good simple SQL tool for Oracle.
It supports schema browsing, analyse plan, limited debugging plus all the stuff you'd expect.
I've used Squirrel-SQL (which is a Java/JDBC based program and will work with any OS or database that provides a driver) and the database development tools for Eclipse (Eclipse-DTP). Both are certainly sufficient for light database work. Both are free and open-source.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With