Input
- xmlrelation_input, as in XMLRelation Example 1: OutputType ('fulldata')
SQL Call
SELECT * FROM XMLRelation (
ON xmlrelation_input
USING
TextColumn ('xmldocument')
DocIDColumns ('xid')
MaxDepth (3)
OutputType ('parentchild')
) AS dt ORDER BY 1,2;
Output
The output table shows the attribute, value, and parent node for each node.
xid | out_nodeid | element | attributes | value_col | parent_id |
---|---|---|---|---|---|
1 | 1 | School | name=UCLA | ||
1 | 2 | Dept | name=EE | 1 | |
1 | 3 | Class | A=grad,B=undergrad | 2 | |
1 | 4 | Student | Harry | 3 | |
1 | 5 | Grade | A+ | 3 |