--使用该SQL查询节点情况
SELECT *
FROM (SELECT * FROM table_a a) t,
xmltable('$B/Message/parent/nood' passing xmltype(t.column_clob_xml) AS b columns attribute1
VARCHAR2(50) path 'attribute1',
attribute2 VARCHAR2(50) path 'attribute2',
attribute3 VARCHAR2(50) path 'attribute3');
SELECT *
FROM (SELECT * FROM table_a a) t,
xmltable('$B/Message/parent/nood' passing xmltype(t.column_clob_xml) AS b columns attribute1
VARCHAR2(50) path 'attribute1',
attribute2 VARCHAR2(50) path 'attribute2',
attribute3 VARCHAR2(50) path 'attribute3');