I've started using Oracle SQL*Plus for school. Having used bash for a long long time, I'm very accustomed to the up-arrow providing command history for me. Currently, the up-arrow transmits ^[[A to the screen. Is there something I can do to enable the command history? I am running SQL*Plus Release 220.127.116.11.0 and am ssh-ing into the machine which has the databases on it.
Unforutunatelly, I'm afraid you can't do that ... if you find out, let me know
However, you can recall last command (query) entering "L" (List) at the SQL prompt. If your query consists of multiple lines, enter, for example, "L 3" to view 3rd line.
Then you can change it using "C/old_string/new_string/" (C-change).
If you need to append something at the ond of a line, enter "A something".
Finally, enter "/" or "R" (R-run) to execute the query.