select * from xmltable(
'$B/Person/Student' passing ---这里指定根节点
xmltype(
'< xml version="1.0" encoding="gb2312" >
') as B
columns ---指定列名称
name varchar2(32) path '/Student/name',
sex varchar2(4) path '/Student/sex',
age number(10) path '/Student/age'
);