I am using SQL Plus to run my SQL commands, and I was wondering is there any way to make it so that when i run a command over several lines i can go back up a line to correct an error?
For example, if this was my command:
SELECT colA, colB
WHERE colA = 100;
Say when I was done with this that I wanted to add "colC" to my SELECT. When I am using SQL Plus right now I cannot use my mouse or directional keys to go back up to my select statement. Is there a way to do this other than writing everything in notepad and copy/pasting?