How to resolve Backspace key issue in sqlplus.

Backspace key does not work in sqlplus.


It's not a issue form Oracle. This is a terminal type issue.


echo $TERM


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


I hope it’s working now.


Alternate way you can use.


  1. Type stty erase in the terminal

  2. Press CTRL+v on your keyboard

  3. Press the Backspace Key on the keyboard (when I did this it put ^H on the line so my final line looked like stty erase ^H)

  4. Press enter

Now restart SQLPLUS you are able to use the backspace key to delete mistyped characters.

38 views0 comments

Recent Posts

See All

How to set cursor movement in oracle SQL

While you are working on SQL*Plus and RMAN on Linux environment and you did some mistake and you want to edit your query it won’t work by default. There is way to configure it. The rlwrap (readline wr