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.

210 views0 comments

Recent Posts

See All

Oracle Database 21c is the first Oracle database release with CDB-only architecture. Oracle 20c was announced only CDB architecture but it was not release for on premises. Only for Cloud. That's why i

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