Use the XML Input page of the New XML Table Function wizard
to
specify the data type and length for the XML document input parameter.
- CLOB
- Specifies that the
data type of your XML document is a CLOB. A CLOB (character
large object) is a sequence of characters (single-byte, multibyte,
or both)
with a size ranging from 0 to 2 gigabytes less 1 byte. In general,
CLOB values
are used whenever a character string might exceed the limits of the
VARCHAR
type.
- Length
- Type the length for
the XML document input parameter. The maximum length
is 4 megabytes.
- Unit
- Select
a unit for your length
- VARCHAR
- Specifies that the data type is a VARCHAR.
- Length
- Type the length for the XML document input
parameter.