By default, SQL*Plus does not support command history on Linux, which makes the tool difficult to use out of the...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.