SQL * Plus direction keys cannot be used in Linux

In a Linux operating system, it is troublesome to use the SQL * Plus tool of Oracle: After you use the SQL Plus command to log on to the SQL * Plus console, in Bash, the used up and down keys suddenly become ^ [[A ^ [[B ^ [D ^ [[C "garbled ". If you are familiar with ksh, you must say that this is a big fuss. However, for general users who transfer data from the Windows platform, If you accidentally press the wrong button, it will be four wrong characters, in addition, historical commands cannot be easily retrieved, which is indeed depressing.

Don't worry. If your Linux is Debian or Ubuntu/Kubuntu, run sudo apt-get install rlwrap to install this small readline extension, then you can use rlwrap sqlplus to enter the SQL * Plus of the direction key "normal. Of course, if you think it's hard to repeat rlwrap each time, you can try/etc/profile or your own ~ /. Add alias sqlplus = 'rlwrap sqlplus 'to bashrc '. For other releases, you can select the rpm package or compile the package from the source code.