A script-enabled browser is required for this page to function properly.

Column Specifications Property

Description

The Column Specifications property dialog allows you to set attributes for a column, including: Column Name, Column Value, Data Type, Length, and Semantics.

Applies to record group

Set Oracle Forms

Column Names

Specifies the names of the columns in a record group.

Required/Optional At least one column must be defined.

Default

Names of the columns in the underlying record group.

Column Value

For a static record group, specifies the row values for the column currently selected in the Column Name list.

Default: NULL

Data Type

Specifies the data type for a given record group column.

Default: CHAR, except when you define a query record group, in which case, the data type of each column defaults to the data type of the corresponding database column.

Restrictions

The data type of a record group column can only be CHAR, NUMBER, or DATE.

Length

Specifies the length, in characters, of the record group column currently selected in the Column Name list.

Default: For a query record group, the default is the width specified for the column in the database. For a static record group, the default is 30.

Required/Optional required

Semantics

Specifies semantics to be used: Null, BYTE, or CHAR.

Usage Notes

The column names must adhere to object naming standards. There can be up to 255 columns in a record group.

Column Specifications Restrictions