The GETLENGTH function returns the number of nodes in a node list. It is commonly used to obtain an upper limit before traversing nodes or to implement secure access when combined with ITEM.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
Note
For V4.4.2, this subprogram is available starting with OceanBase Database V4.4.2 BP2.
Syntax
DBMS_XMLDOM.getLength (
nodelist IN DBMS_XMLDOM.DOMNODELIST);
Parameters
Parameter |
Description |
|---|---|
| nodelist | The DBMS_XMLDOM.DOMNODELIST handle to count. |
Return value
The number of nodes in the node list, of type NUMBER.
Considerations
Indices start at 0, and the valid range is [0, GETLENGTH(nodelist) - 1]. If the list is empty, 0 is returned.