|
|
|
|
|
This statement is used to specify the display format of a column in the subsequent query.
Specify the following:
the name of the column you are formatting
the number of the column you are formatting.
You must specify either colno or colname but not both.
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
