Solved

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

Posted on 2001-07-20
6
475 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

751 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