Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Backspace doesn't work in sqlplus command line

In my sqlplus (for oracle) command line, the backespace doesn't work. How could I configure sqlplus for deleting characters from the command line with backspace? I don't use frequently sqlplus command line, only for making quickly interventions in my DB, it is very hazard for me the times I need to use.

Kind Regards. Thanks

like image 818
Alexis Sánchez Tello Avatar asked Apr 24 '14 12:04

Alexis Sánchez Tello


People also ask

How do I edit a previous line in SQL?

Use the LIST command (or just the line number) to list the line you want to change. Enter APPEND followed by the text you want to add.

What is the maximum Linesize in Sqlplus?

The LINESIZE setting controls the number of characters SQL*Plus prints on one physical line. The default setting is 80 (150 in iSQL*Plus). The maximum width is system-dependent, though it's often 32,767 characters.


1 Answers

Following the instructions here I was able to do the following and get this working:

  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 if I start up sql plus I can use the backspace key to delete mistyped characters.

like image 175
Chris Magnuson Avatar answered Sep 20 '22 23:09

Chris Magnuson