Oracle SQL Plus Pocket Reference, 2nd Edition

Name

CLEAR

Synopsis

CL[EAR] {BRE[AKS] | BUFF[ER] | COL[UMNS] |
    COMP[UTES] | SCR[EEN] | SQL | TIMI[NG]}

The CLEAR command allows you to easily delete all column definitions, break settings, compute definitions, and so forth. For example:

CLEAR BREAKS
CLEAR COMPUTES

Parameters

BRE[AKS]

Deletes any break setting you may have defined using the BREAK command.

BUFF[ER]

Erases the contents of the buffer.

COL[UMNS]

Deletes any column definitions you may have made using the COLUMN command.

COMP[UTES]

Deletes any computations you may have defined using the COMPUTE command.

SCR[EEN] (not supported in iSQL*Plus)

Clears the screen.

SQL

Erases the contents of the SQL buffer.

TIMI[NG]

Deletes any timers you may have created using the TIMING command.