arrow keys are not functional in sqlplus

keyboard sqlplus key
daizuozhuo picture daizuozhuo · Mar 27, 2012 · Viewed 21.6k times · Source

I find that the arrow keys don't work on the sqlplus console. For example if I press left arrow key, it shows like

SQL>^[[B

Does any solutions exist to solve this problem?

Answer

Johnny Baloney picture Johnny Baloney · Apr 23, 2012

You can use a third party utility called rlwrap.

rlwrap is a readline wrapper, a small utility that uses the GNU readline library to allow the editing of keyboard input for any other command. It maintains a separate input history for each command, and can TAB-expand words using all previously seen words and/or a user-specified file.

So you will be able to use arrows and also get a command history as a bonus.

After you have installed the utility run sqlplus the following way:

$ rlwrap sqlplus

Related questions

Getting Keyboard Input

How do I get simple keyboard input (an integer) from the user in the console in Java? I accomplished this using the java.io.* stuff, but it says it is deprecated. How should I do it now?

Read More
How to read keyboard-input?

I would like to read data from the keyboard in python I try this: nb = input('Choose a number') print ('Number%s \n' % (nb)) But it doesn't work, neither with eclipse nor in the terminal, it's always stop of the …

Read More
How to show soft-keyboard when edittext is focused

I want to automatically show the soft-keyboard when an EditText is focused (if the device does not have a physical keyboard) and I have two problems: When my Activity is displayed, my EditText is focused but the keyboard is not …

Read More