Input
- xmlrelation_input, as in XMLRelation Example: OutputType ('fulldata')
SQL Call
SELECT * FROM XMLRelation(
ON xmlrelation_input
USING
TextColumn('xmldocument')
DocIDColumns('xid')
MaxDepth(3)
OutputType('parentchild')
) AS dt;
Output
The output table shows the attribute, value, and parent node for each node.
xid out_nodeid element attributes value_col parent_id --- ---------- ------- ------------------ --------- --------- 1 4 Student Harry 3 1 5 Grade A+ 3 1 3 Class A=grad,B=undergrad 2 1 2 Dept name=EE 1 1 1 School name=UCLA NULL
Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.