Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

CLEAR

Synopsis

The CLEAR command deletes all column definitions, break settings, compute definitions, etc.

Syntax

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

Parameters

CL[EAR]

Is the command, which may be abbreviated CL.

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]

Clears the screen. Does not apply to iSQL*Plus.

SQL

Erases the contents of the SQL buffer.

TIMI[NG]

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