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
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.
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.
Following the instructions here I was able to do the following and get this working:
stty erase
in the terminalCTRL+v
on your keyboardBackspace Key
on the keyboard (when I did this it put ^H
on the line so my final line looked like stty erase ^H
)Now if I start up sql plus I can use the backspace key to delete mistyped characters.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With