基于XML Clob搜索字符串从oracle中提取行

SELECT * FROM V$OPTION WHERE PARAMETER = 'XML';

SELECT *
FROM XMLTable(
  '/root/row'
  PASSING XMLTYPE('<root>
                    <row>
                      <id>1</id>
                      <name>John</name>
                    </row>
                    <row>
                      <id>2</id>
                      <name>Jane</name>
                    </row>
                  </root>')
  COLUMNS "ID" NUMBER PATH 'id',
          "NAME" VARCHAR2(50) PATH 'name'
);

CREATE TABLE my_table (
  xml_data XMLTYPE
);

INSERT INTO my_table (xml_data)
VALUES (XMLTYPE('<root>
                  <row>
                    <id>1</id>
                    <name>John</name>
                  </row>
                  <row>
                    <id>2</id>
                    <name>Jane</name>
                  </row>
                </root>'));

CREATE INDEX xml_data_idx ON my_table(xml_data) INDEXTYPE IS XDB.XMLINDEX;