Sqlplus can not use the backspace bar problem processing

may have used sqlplus people know that in the Sqlplus connection Oracle after the session interface is unable to use the arrow keys and backspace, this is a more troublesome point, often have a SQL write wrong, can not be modified to start again very troublesome, People who have used MySQL must not get used to it, but fortunately there are 2 useful tools available under Linux to solve this problem, they are rlwrap and ReadLine, Through the two tools to start sqlplus can solve the problem of editing in the session and add a system-like history of the features, of course, the installation is recommended to configure the Yum source, remember to configure the source of Epel, configured directly through Yum installation, Then in the modified under the Oracle User environment configuration file, to Sqlplus and Rlwrap alias, so that the next time the province to repeat the input instructions, the operation is very simple, as follows:

[Email protected] ~]# yum-y install readline rlwrap[[email protected] ~]# su-oracle[[email protected] ~]$ vim. BASH_PR Ofile ... A little ... alias sqlplus= ' Rlwrap sqlplus ' Alias rman= ' Rlwrap rman ' [[email protected] ~]$ source. bash_profile

This allows you to use the same sqlplus session as you would in the MySQL session.

This article from the "Technical essay" blog, reproduced please contact the author!

Sqlplus can not use the backspace bar problem processing