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]
Clears the screen.
- SQL
Erases the contents of the SQL buffer.
- TIMI[NG]
Deletes any timers you may have created using the TIMING command.
Get Oracle SQL*Plus Pocket Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.