. CLPPlus command

The . CLPPlus command is similar to a No Operation Performed (NOOP or NOP) machine language command. It is ignored when entered on its own with no other CLPPlus command.

The . CLPPlus command can also be used to skip the currently entered command and move to the next SQL> prompt. This can be done by entering the command on its own on a new line in the current block of code. This can help you cancel a command when you enter an incorrect entry. A cancelled command is available in the history and can be accessed and edited.

Invocation

You must run this command from the CLPPlus interface or from within a CLPPlus script file.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagram.

Example

In the following example, the . command is used to cancel the current command.

SQL> begin
       2 dbms_output.putline('wrong put_line');
       3 .
SQL>