如何将XMLTABLE (Oracle SQL)与属性名称结合使用

CREATE TABLE example (
    id NUMBER,
    xml_data CLOB
);

INSERT INTO example (id, xml_data) VALUES (
    1,
    '<?xml version="1.0" encoding="UTF-8"?>
    <root>
        <item id="1">
            <name>Item 1</name>
            <price>100</price>
        </item>
        <item id="2">
            <name>Item 2</name>
            <price>1000</price>
        </item>
    </root>'
);

SELECT x.id, x.name
FROM example e,
     XMLTABLE('/root/item' PASSING XMLTYPE(e.xml_data) AS xml
             RETURNING CONTENT AS item,
             XMLATTRIBUTES(x.id AS id, x.name AS name)) x;

    id   name
----------    1    Item 1
    2    Item 2