SQL*Plus User's Guide and Reference Release 8.1.6 A75664-01 |
|
Command Reference, 13 of 52
Resets or erases the current value or setting for the specified option.
CL[EAR] option ...
where option represents one of the following clauses:
BRE[AKS] BUFF[ER] COL[UMNS] COMP[UTES] SCR[EEN] SQL TIMI[NG]
Refer to the following list for a description of each term or clause:
BRE[AKS]
BUFF[ER]
Clears text from the buffer. CLEAR BUFFER has the same effect as CLEAR SQL, unless you are using multiple buffers (see the SET BUFFER command in Appendix F).
COL[UMNS]
COMP[UTES]
SCR[EEN]
SQL
Clears the text from SQL buffer. CLEAR SQL has the same effect as CLEAR BUFFER, unless you are using multiple buffers (see the SET BUFFER command in Appendix F).
TIMI[NG]
To clear breaks, enter
SQL> CLEAR BREAKS
To clear column definitions, enter
SQL> CLEAR COLUMNS
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|