Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Backspace key does not work in sqlplus.

SOLVED
Go to solution
Jack C. Mahaffey
Super Advisor

Backspace key does not work in sqlplus.

Any ideas why the backspace will not work in sqlplus or svrmgrl?

thanks....
7 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: Backspace key does not work in sqlplus.

This is a terminal type issue.

echo $TERM

stty -a and see if you have done anything special with the backspace key.

Attaching mine as a reference. My backspace key does work in sqlplus.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
A. Clay Stephenson
Acclaimed Contributor

Re: Backspace key does not work in sqlplus.

There is nothing special about sqlplus or svrmgrl; they simply use the erase key as defined by your TERM setting. Do a stty -a (as whatever user is actually running sqlplus) and note the 'erase=' value. You thgen need to make certain that your terminal (or terminal emulator) is indeed generating that key OR use the stty command to define a matcvhing erase character.
If it ain't broke, I can fix that.
Umapathy S
Honored Contributor

Re: Backspace key does not work in sqlplus.

Jack,
Mostly term problems. try stty erase ^? before opening sqlplus

HTH,
Umapathy
Arise Awake and Stop NOT till the goal is Reached!
Bill Hassell
Honored Contributor

Re: Backspace key does not work in sqlplus.

If you are not using a 'real' terminal but an emulator, most likely it is a VT100 lookalike, perhaps supplied with an Xwindow package, and many of these programs default to VMS mode for backspace which means the backspace key on the keyboard transmits the DEL character. If stty -a shows that erase = ^H then configure your terminal emulator to map backspace = backspace rather than backspace = deleteKey.


Bill Hassell, sysadmin
Jack C. Mahaffey
Super Advisor

Re: Backspace key does not work in sqlplus.

Thanks all. My .profile was setting erase to ^H


jack...
Jack C. Mahaffey
Super Advisor

Re: Backspace key does not work in sqlplus.

Typo in last response. My .profile was setting erase to ^?
Bill Hassell
Honored Contributor

Re: Backspace key does not work in sqlplus.

FYI: ^? is the DEL (delete) key.


Bill Hassell, sysadmin