Alternatives to Toad

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.

Oracle's SQL Developer.