I'm dreaming about a sqlplus (as like bash) be able to do auto completion behavior for commands, having a bigger history of commands than only 1 in the buffer and a syntaxe control in order to avoid errors.
A more detailled online help would also be perfect!
I am very angry about Oracle support & develoeprs. They do not care about the situation and problems of the community. Your advice is a good example. That limitation of sqlplus exist before oracle has yet been developed ! I think sqlplus cames before the DBMS *g and only marketing makes oracle a global player instad of genius implementations.
Maybe oracle has no QA-Department that has experiences in usability :)
Have you tried SQL Developer (free product)? It may be what you are looking for.
As someone that was trained to be an Oracle DBA via svrmgr and sqlplus, I am a bit comfortable in the command line of sqlplus, but I think the usability factor is GREATLY increased with SQL Developer. It has a lot of the features you mentioned.