You can use a number of SQL*Plus commands to edit the SQL command or PL/SQL block currently stored in the buffer.
The SQL*Plus CHANGE command enables you to edit the current line. Various actions determine which line is the current line:
- LIST a given line to make it the current line.
- When you LIST or RUN the command in the buffer, the last line of the command becomes the current line. (Note, that using the slash (/) command to run the command in the buffer does not affect the current line.)
- If you get an error, the error line automatically becomes the current line.