Clearing Column Formatting

You clear the formatting for a column using the CLEAR option of the COLUMN command. For example, the following COLUMN command clears the formatting for the product_id column:

 SQL>  COLUMN product_id CLEAR  

You can clear the formatting for all columns using CLEAR COLUMNS . For example:

 SQL>  CLEAR COLUMNS  columns cleared 

Once you ve cleared your columns, the output from queries will use the default format for the columns.