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.