By default, SQL*Plus does not support command history on Linux, which makes the tool difficult to use out of the
box. I spent weeks looking for a solution to this problem on Google. I finally found this at http://www.dizwell.com/html/cli_history.html:
- Install rlwrap on your system. On gentoo I emerged it so in debian or other distros there should be an RPM or package available.
- Edit your /home/you/.profile and add alias sqlplus='rlwrap sqlplus'
- Source /home/you/.profile
SQL*Plus now supports command history.