Scripting - ColFormat

This statement is used to specify the display format of a column in the subsequent query.

Specify the following:

• colname

  the name of the column you are formatting

• colno

  the number of the column you are formatting.

  You must specify either colno or colname but not both.

• format

  the format to be applied to the column. The values you can specify are given in Formatting Data

Example:

--aqt colformat,colname=salary,format=currency

Select * from test.employee

If you wish to format more than one column, you can do this either on separate format lines, or on the same line:

--aqt format,colno=5,format=$###,##0.00,colno=6,format=yyyy-MM-dd

Select * from test.employee