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.