Solved

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

Posted on 2001-07-20
6
463 Views
Last Modified: 2007-12-19
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
Comment
Question by:jasonashaw
  • 3
6 Comments
 
LVL 3

Accepted Solution

by:
interiot earned 50 total points
ID: 6302623
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
 
LVL 3

Expert Comment

by:interiot
ID: 6302767
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
 

Author Comment

by:jasonashaw
ID: 6302801
Thanks very much.
0
 
LVL 3

Expert Comment

by:interiot
ID: 6302850
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
 
LVL 20

Expert Comment

by:jmcg
ID: 9871661
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

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

The purpose of this article is to fix the unknown display problem in Linux Mint operating system. After installing the OS if you see Display monitor is not recognized then we can install "MESA" utilities to fix this problem or we can install additio…
The purpose of this article is to demonstrate how we can upgrade Python from version 2.7.6 to Python 2.7.10 on the Linux Mint operating system. I am using an Oracle Virtual Box where I have installed Linux Mint operating system version 17.2. Once yo…
This video discusses moving either the default database or any database to a new volume.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now