Why won't sqlplus give me a command history?
I was using oracle 11g on a windows vm. The vm broke itself to an irreparable state and I decided I would use a slackware VM so I can maintain a usable install of 11g.
After a pain in the ass of a time I got it running. I am doing homework and when I press up to edit a command I've given previously all I get is ^[[A. I can't even use home or end keys. Why can't I get a history on sqlplus? I'm used to just being able to push "up." I can't even paste code in with the intention of editing it because it runs it immediately and fails. Even when I edit it in an editor and paste it it seems to detect line breaks or something and errors out. |
Hi
You must remember that SQLPlus is not your shell. It doesn't have the same capabilities. Oracle sqlplus documentation here. You're probably better off doing your editing in an editor and running the script from sqlplus. Something like: Code:
sqlplus username/password @name_of_file_containing_sql_script |
It can do it in windows so I'm kind of confident it must work in linux. There's got to be some kind of command history file I can set with an environment variable or something.
HAZAAH I am [edit] apparently not [edit] victorious! Quote:
Quote:
|
Okay last thing didn't work. Don't know what I'm doing with the vi stuff. I found this:
http://utopia.knoware.nl/~hlub/rlwrap/man.html Got a buildscript from slackbuilds.org and used it. Works perfectly. All is right with the world. |
All times are GMT -5. The time now is 01:59 AM. |