Solved

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

Posted on 2001-07-20
6
469 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Have you ever been frustrated by having to click seven times in order to retrieve a small bit of information from the web, always the same seven clicks, scrolling down and down until you reach your target? When you know the benefits of the command l…
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…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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