By default, SQL*Plus does not support command history on Linux, which makes the tool difficult to use out of the...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.