Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


The COLWIDTH option controls the default width of data columns in report output. For output from the ROW command and HEADING command, COLWIDTH affects all columns except the first column. For output from REPORT, COLWIDTH affects all data columns, as well as the label columns for a composite or a conjoint dimension.

Data type






An INTEGER expression that specifies the desired column width in number of characters. You can use an INTEGER literal or an expression that returns an INTEGER value. The default is 10.


Label Columns in REPORT

By default, the REPORT command produces a column of dimension values labeling the rows down the left side of the report. The default width of this label column is controlled by the LCOLWIDTH option, which has a default value of 14 characters. However, when the DOWN phrase in a REPORT command specifies a composite or a conjoint dimension, Oracle OLAP creates a separate column for each base dimension. The default width of these base dimension columns is controlled by the COLWIDTH option.

Maximum Column Width

You can set COLWIDTH to any value from 1 to 4000.


The maximum width of a line in a report is 4000 characters. Therefore, the combined width of all the columns of a report cannot be greater than 4000 characters.

Overriding COLWIDTH

For an individual column, the COLWIDTH value is always overridden by a WIDTH attribute in a HEADING, REPORT, or ROW command.


Example 9-8 Setting the Default Column Width in a Report

Suppose you want to look at unit sales for six months. Since the data values are not large, you do not need a width of 10 characters for your data columns. You can set COLWIDTH to provide a narrower default column.

LIMIT district TO 'Atlanta'
LIMIT month TO 'Oct95' TO 'Mar96'
REPORT ACROSS month: units

These statements produce the following output.

PRODUCT        Oct95  Nov95  Dec95  Jan96  Feb96  Mar96
-------------- ------ ------ ------ ------ ------ ------
Tents             503    345    259    279    305    356
Canoes            317    282    267    281    309    386
Racquets        1,365  1,270  1,357  1,125  1,304  1,263
Sportswear      3,065  2,327  1,955  2,591  2,829  3,137
Footwear        3,445  3,247  2,831  3,089  3,282  3,475