Oracle has now been the dominant database for quite some time now. It is indeed a powerful database, with a plethora of high end features. Why is it then that the primary interface for the database administrator is a poor command line tool, which has remained essentially unchanged for more than 10 years?
Yes, I'm talking about good old SQL*Plus. Despite being used by a generation of DB administrators, it lacks simple functionality which would greatly ease the administrator’s life.
In particular:
• Line editing capabilities. I can't tell you how many times I've typed a long SQL statement just to realize that I had typed "selct" way back at the beginning. Sqlplus does have (weak) sed-like editing capabilities, and the ability to edit the previously run command in your choice of editor, but that's only AFTER you've executed your faulty command. From what I've seen, "backspace" seems to be the editing method of choice.
• History. Sqlplus only stores the last command you have run. But when I'm looking around in several tables, I need to go back and recover previous commands. Almost invariably, I end up opening another window just so I can copy the commands that I need to run repeatedly.
• Table/Field name completion. Every modern IDE has the useful feature of allowing code completion -- you type part of a command, and the IDE can suggest what you want to enter.