Use the Add Column Definition window of the
New XML Table Function
wizard to specify information about the column definitions.
- Relative
path
- Type a path to the column element relative to the row
element. For example, author where
the table path is Books/Literature/ and the row path
is Book.
- Name
- Type
a column name (up to 18 characters) for the UDF RETURNS TABLE clause.
- SQL Type
- Select the column
data type for the UDF RETURNS TABLEclause.
- Length
- Type a length for the
selected SQL type. This field is available only
for the following SQL types: BLOB, CHAR, CLOB, DBCLOB, GRAPHIC, and
VARCHAR.
- Unit
- Select a
unit size (bytes, kilobytes, megabytes, or gigabytes) for the
selected SQL type. This field is available only for the following
SQL types:
BLOB, CLOB, and DBCLOB.
- Precision
- Type a number (between 1 and 31) for the total number of digits
that the
value can contain. This field is available only for the SQL types
DECIMAL
and FLOAT. The precision of binary integers and decimal numbers is
the total
number of binary or decimal digits excluding the sign. The precision
of floating-point
numbers is either single or double, referring to the number of digits
in the
fraction.
- Scale
- Type a
number for the number of digits to the right of the decimal point.
This field is available only for the SQL types DECIMAL and FLOAT.
The scale
cannot be negative or greater than the precision. The maximum precision
is
31 digits; therefore, the precision plus the scale must be 31 digits
or less.
If you specify a scale, you must also specify a precision. By default,
the
scale is zero.