It has always bugged me that the Oracle SQLPlus prompt on Windows allowed you to use the up arrow to repeat (and most often used to fix) the previous command but for some reason this functionality is lost with the Linux version. That is until now.
I started to Google around to see how to turn this functionality on and that when I found the Holy Grail of SQL prompts; GQLPLus. ”The difference between gqlplus and sqlplus is command-line editing and history, plus table-name and column-name completion.”
After downloading the gzip you can either compile the code your self, which didn’t work for me or just take the easy route and use the pre-complied binary located int he Linux folder of the gzip file. I copied this binary to the /usr/local/bin folder for easy access.
You can download the source and binaries from the GQLPlus sourceforge page