SQL command in SSH to press backspace key garbled problem resolved

With SSH call sqlplus input SQL statement, press BACKSPACE (BACKSPACE) appear ^h garbled as follows:

[Email protected] ~]$ Sqlplus/as SYSDBA

Sql*plus:release 10.2.0.1.0-production on Fri June 6 00:09:23 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production
With the partitioning, Oracle Label Security, OLAP and Data Mining options

Sql> fafafafafafaf^h^h^h^h

^h is not the meaning of H-key, but backspace. You need to set it up when you have a problem with your terminal backspace.

In the Linux environment to use Sqlplus, in the back (BACKSPACE) often appear garbled. Garbled is the result of Oracle's Sqlplus not using the GNU ReadLine Library.

There are two ways to resolve this:

1. To use the back Delete key (BACKSPACE), hold down the CTRL key while

2. Setting environment variables will stty erase ^h or stty erase ^? To add to. bash_profile, set the profile of the Oracle user as follows:

[Email protected] ~]$ Vi./.bash_profile
#. Bash_profile

# Get the aliases and functions
If [-f ~/.BASHRC]; Then
. ~/.bashrc
Fi

# User specific environment and startup programs

Path= $PATH: $HOME/bin

Export PATH
Export Oracle_base=/u01/app/oracle
Export Oracle_home= $ORACLE _base/product/10.2.0/db_1
Export path= $ORACLE _home/bin: $PATH
Export ORACLE_SID=OMR
Export Oms_home= $ORACLE _base/product/10.2.0/oms10g/oms10g
Export Agent_home= $ORACLE _base/product/10.2.0/oms10g/agent10g
Stty Erase ^h