I presume you are using Win OS. What you need to do is ...
1. Get SQL Navigator ... which solves all your problems of any complexity
Disadvantage: Its so bloody good product that you dont have to remember any command of any database for creation..modification etc
. In this process the development velocity would be atleast 20-50 times more than manual PL/SQL editor .. Over a peroid of time when you want to get rid of this ..it could take some time
But neverthless a perfect editor
Let me know what u think
Keep things simple as the world is already complex
I'd appreciate any recommendations between PL/SQL (for example with with PL/SQL Developer), Dreamweaver, Cold Fusion, ASP, and so on.
I normally use vi or JEdit and sqlplus for all my PL/SQL development, and it works just fine.
If you want something graphical, many people like Toad or its open-source clone, Tora.
I've also read that JDeveloper is very good for PL/SQL, not for Java only (i've read that in the latest book by Tom Kyte, so it's definitely a good recommendation!), offering color syntax highligthning, auto completion and the like.
For all-pl/sql development, there's HTMLDB, that generates the html pages directly from the database. It's brand-new but IMHO a great idea.