[Solved] How to Use "Backspace" key at SQL> Prompt in Oracle

To use backspace key at SQL> prompt in oracle, you've to trap the backspace key signal which is "^H".

So, you have to use below command in your user .profile or .kshrc, .bashrc etc shell.

stty erase ^H

Example: Before

[oracle@ole1 ~]$ 

[oracle@ole1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 2 23:16:07 2014

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select sysdate from ^H^H^H^H^H^H^H^H^C

SQL> 

Example: After

[oracle@ole1 ~]$ stty erase ^H

[oracle@ole1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 2 23:06:19 2014

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select sysdate from dual;

SYSDATE

---------

02-NOV-14

SQL>