If we're going to take a look at what we have now, the most well known Oracle IDEs are:
Tora... but I would rather mention it on past tense.
So, what I don't like about these tools? Let's see:
- They are heavy... some of them take a lot of time just to startup.
- Most of them are not cross platform.
- They are closed software. You don't have access to the code.
- Limited editing features. I know they offer templates, auto-complete and stuff, but they look so small in comparison with what VIM provides.
- They are not suitable for server environments. I mean... what if you have to connect to the database on a remote Unix server, connected via ssh within a "friendly" console? I guess sqlplus is all you have there and it's not a very pleasant experience.
- A lot of the so useful sqlplus commands doesn't work in these environments. PLSQL Developer does a good job emulating many of these commands but I still miss AUTOTRACE, sub-totals and all the other cool features sqlplus provides.