RUN CLPPlus command

The RUN CLPPlus command runs a SQL query or a PL/SQL command that is stored in the SQL buffer.

Invocation

You must run this command from the CLPPlus interface.

Authorization

None

Required connection

You must be connected to a database.

Command syntax

Read syntax diagramSkip visual syntax diagramRUN

Example

In the following example, the contents of the SQL buffer is populated with the SELECT EMPNP FROM EMP statement.
   SQL> APPEND SELECT EMPNP FROM EMP
The RUN command issues the statement in the SQL buffer: 
   SQL> run
     1* SELECT EMPNO FROM EMP
The output is as follows:
   EMPNO
   -------
   000010
   000020
   ...
   ...