Skipping and interrupting CLPPlus commands

CLPPlus allows you to skip and interrupt command execution as well as script execution.

You can interrupt any command or script that CLPPlus is running using the Ctrl+C keystroke. This is helpful when you encounter a long running query or script and need to return control back to the CLPPlus interface.

You can also skip to the next SQL> prompt by pressing the ENTER key twice in succession. This is helpful when you enter an incorrect command and want to cancel it. The incorrect command is retained in the buffer and can be edited using any of the CLPPlus commands you use for editing and review.

Examples

The following example shows a command being skipped.

SQL> select *
  2  from employee                <- first carriage return
  3                               <- second carriage return
SQL>                              <- next sql prompt