asked on

configure xterm environment for sql*plus to enable scrolling through previous commands

Pleas ehelp. I am trying to configure my xterm environment for sql*plus to enable scrolling through previous commands. (ie up arrow to previous command)

Currently it works fine in my normal zsh shell, but when I run sqlplus and get the command prompt SQL>, the up or down arrow produces these charaters: up=^[[A and down=^[[B

Please help. What files do I need to modify and how?

Thanks,
Jason

ASKER CERTIFIED SOLUTION

interiot

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

interiot

FYI: the ability to do command history in sql*plus has nothing to do with your shell, and little to do with your terminal. It depends a great deal on the method that the sqlplus program uses to read the input, because it has to enable the use of the arrow keys within itself.

SqlPlusPlus is a front-end to SqlPlus which processes the up and down keys. When you finish typing a command, it sends it to the real sqlplus to be run.

jasonashaw

ASKER

Thanks very much.

interiot

Glad to help. If that's all you need for this question, please click the "Accept Comment as Answer" button next to the comment that helped the most.

jmcg

No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: interiot {http:#6302623}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jmcg
EE Cleanup Volunteer