• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 486
  • Last Modified:

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
0
jasonashaw
Asked:
jasonashaw
  • 3
1 Solution
 
interiotCommented:
You'll want to download this program (aptly named sqlplusplus), compile it, and run it in place of using sql*plus interactively.

   http://www.doag.org/orafaq/scripts/c_src/sqlpp.txt
0
 
interiotCommented:
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.
0
 
jasonashawAuthor Commented:
Thanks very much.
0
 
interiotCommented:
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.
0
 
jmcgOwnerCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now