SQL*Plus does not support command history on Linux

This tip demonstrates how to change SQL*Plus so that it supports command history on Linux.

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:

  1. Install rlwrap on your system. On gentoo I emerged it so in debian or other distros there should be an RPM or package available.
  2. Edit your /home/you/.profile and add alias sqlplus='rlwrap sqlplus'
  3. Source /home/you/.profile

SQL*Plus now supports command history.

This was last published in September 2005

Dig Deeper on Oracle and SQL

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close