SQL Plus - Clear

Card Puncher Data Processing

About

CLEAR resets or erases the current value or setting for the specified option.

Syntax

 CL[EAR] option ...

where option represents one of the following clauses:




Discover More
Card Puncher Data Processing
SQL Plus - Break

BREAK specifies where changes occur in a report and the formatting action to perform, such as: suppressing display of duplicate values for a given column skipping a line each time a given column value...
Card Puncher Data Processing
SQL Plus - Column Command

The column command: specifies display attributes for a given column, such as: text for the column heading alignment for the column heading format for NUMBER data wrapping of column data lists...
Card Puncher Data Processing
SQL Plus - Command Reference

Commands Description @ @@ / ACCEPT APPEND ARCHIVE ATTRIBUTE BREAK BTITLE CHANGE CLEAR COLUMN COMPUTE CONNECT COPY Copies data from a query to a table in the same or another...
Card Puncher Data Processing
SQL Plus - Formatting Reports

How to format SQLplus output (ie ) All below parameters can be configured in the login script. Through the SQLPlus COLUMN command with the heading options, you can change the column headings...
Card Puncher Data Processing
SQL Plus - SQL Buffer

The SQL Buffer contains the most recently executed: SQL command or PL/SQL block The buffer has no command history list and does not record SQLPlus commands. at the beginning, just use 0...



Share this page:
Follow us:
Task Runner